(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.
2006-06-14
17:50:52
·
1 answers
·
asked by
firooz
1