i,m trying to make a conditional combo box ( a look up column)in an access db.please instruct me step by step

Question

(i'm beginner).Suppose i have 4 tables named as t1,t2,t3,t4. and their pertaining fields are named as t1F1,t1F2,t1F3,t1F4(for table "t1") and so on for other tables. eg. when I enter no. "2" in the field "t4F3"' i would get a combo box ( a lookup column from table "t2") in the field "t4F4". Or if I enter no."3" in the same field("t4F3"), I would get a combo box ( a lookup column from table "t3") in the field "t4F4". Should i go to the design view of the Form pertaining to the table "t4" and right click in the text box of t4F4 or t4F3? and make some SQL script( on Build option)? Would you please write exact script accordig to the tables and field names I MENTIONED ABOVE.

Answer 1

One question: when you type "2" in the field t4f3, what do you want to lookup in table 2? Fields? Records? All fields? All records? I believe you're not designing the right way your database. Please be more specific.

Makiavel