I have 2 tables as below :
table1
TEMP PH4 PH7 PH10
30 4 7 7.9
20 6 8 9
10 7 7 7.9
table2
REC TEMP PH4 PH7 PH10
1
2
3
I also have a form relating to table 2 with a combobox for the temp on table1. how can i get the combobox selection to populate the other fields in the form and table2?
This is probably very easy however, having not touched access for some time (7years) I seem to be going round in circles can anyone help
Please
table1
TEMP PH4 PH7 PH10
30 4 7 7.9
20 6 8 9
10 7 7 7.9
table2
REC TEMP PH4 PH7 PH10
1
2
3
I also have a form relating to table 2 with a combobox for the temp on table1. how can i get the combobox selection to populate the other fields in the form and table2?
This is probably very easy however, having not touched access for some time (7years) I seem to be going round in circles can anyone help
Please