Hi All.
I have tables T1 and T2, fields F1 and F2 exist in T1 as well as T2, i also have created a from called FRM1.
T1 is th table i use to enter data that does nto change that often,
T2 is the table with most of the data and also includes the fields of T1.
I use a combo box in FRM1 to get data from T1 and put into T2 along with other fileds i enter data for. The relationship link from T1 to T2 has refernetial integrity and data cascade checked.
The problem i am having is that when i use the combo box for drop down in FRM1 it shows me the proper data from F1 from T1, however , F2 from T1 does not autonatically show the data from T1 in FRM1 once i select F1 from the dropdown box. I am trying to get it to work so that when i select F1 in FRM1 then FRM1 fileds F1 and F2 automatically populate and addd date to T2.
Any help woudl be appreciated, hopefully i have explained the problem reasonably well.
I have tables T1 and T2, fields F1 and F2 exist in T1 as well as T2, i also have created a from called FRM1.
T1 is th table i use to enter data that does nto change that often,
T2 is the table with most of the data and also includes the fields of T1.
I use a combo box in FRM1 to get data from T1 and put into T2 along with other fileds i enter data for. The relationship link from T1 to T2 has refernetial integrity and data cascade checked.
The problem i am having is that when i use the combo box for drop down in FRM1 it shows me the proper data from F1 from T1, however , F2 from T1 does not autonatically show the data from T1 in FRM1 once i select F1 from the dropdown box. I am trying to get it to work so that when i select F1 in FRM1 then FRM1 fileds F1 and F2 automatically populate and addd date to T2.
Any help woudl be appreciated, hopefully i have explained the problem reasonably well.
