Linking of several records on a form to a single subform

[David1234]

Hi,

I have created a link between my form and my subform, I need the main form to be record specific e.g.,

Record 1A - Faulty Item
Record 1B - Damaged Item
Record 1C - Missing Item

These would be reflected in the main for as records 1,2 & 3.

However what I would like to do it link record 1A,1B & 1C together to show on a subform.

Is there any criteria I can set that the master record 1A holds the information in its subform the records 1B & 1C and then going up to 2A,3,4 etc?

 

[Galaxiom]

Derive extra matching fields in the RecordSource queries of the main form and subform then use these as the LinkFields.

These extra fields don't need to be displayed on the forms. However note that you won't be able to add records to the subform.