Values from Mainform to childform in case if...

[cap.zadi]

Hey there,



I have one main form with subform.

Mainform:

frmT5
TestNo
MtrlID (A200, B200, C300, D300) - Combobox, ValueList
Length

frmRT5
RNo
Weight
ADCal
GrsCal



Q1:
so how it could be possible when i select a MtrlID frm list like A200 so its weight shud appear in frmRT5 weight field and same for other items.

Q2:

How it could be for length also if i select MtrlID like C300 So its lenght shud be appearing in length field.

where to define those va;ues with with MTRLID so when ever it is select relevent information appears in those fields.

thanks

zee

[June7]

Not understanding data structure. If Master/Child link properties of the subform container control are set to the primary/foreign keys of the tables data will synchronize. I don't understand the relationship here. If each MtrlID has a fixed length/weight value that can be found in another table, why do you need to save again? Retrieve related info by joining tables in query.