I have a main form and 2 subforms. The output would look like this,
MAIN FORM
Item_ID: 1875A

SUBFORM1
Item_Skey Item_STate Work_Center
400000 1 CM
400000 4 TL

SUBFORM2
Reading_Type Work_Center Table Column
GA CM tblCM_Dtl Trace
PE CM tblCM_Dtl Trace
(When you click on a row in subform1, subform2 would change its data). Column is the field name to retrieve data from that Table.
My question is how can I select a row on Subform2, and I will be able to grap that field from the specified table along with other fields in its Master table (ie: tblCM_Master in this case). Then maybe put all of those fields in another form.
Does anyone know how to do this? Any help would be very much appreciated.
Thanks