To be more specific on my question on conditional combo box on access db.,suppose t4 ( table 4) is a payment?

Question

chq. list. and field "t4F1" is chq. no. and t4F2 is the amount and t4F3 is the no.of table you want to choose the payee from.: Eg. if the payee is your custommers [ say table no. 1 (t1)is the list of your customer ]. Or if your payee is your supplier , then no 2 [ as reprsentative of t2 ( list of suppliers)]should be entered in field t4F3 and so on. ie if you put 1 in t4F3, you will get a lookup column ( cmbo box)of table t1 (in field t4F4) from which you could drop down costomer ID in t4F4 and so on. If this is not right approach please give me right one.

Answer 1

I would submit your questions and/or lookup an answer already posted on http://www.utteraccess.com, it is an excellent troubleshooting resource, forum and community website.