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
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
