Filter subform records to match master record

[rdingman]

I am a user with basic Access experience. I have created a simple database to record inspection records of incoming receipts. The structure is 3 tables as follows:

mastertable: CID - container ID
Date - date of receipt
PO - purchase order number

sampletable CID
Sample - sample number
SampleComment - notes re sample

sampleresults CID
Status - pass or fail

I setup a 3 level form, but how do I filter it so that the sampletable and sampleresults only display based on the open mastertable record? For example, if CID is 10, then the subforms would only displays results for 10.

I will probably need to add an autonumber so that the user can determine which record they are working on. A receipt will have 8 sample sizes for each item number. A container can have several items.

Thanks,
Rick

 

[Remou]

You need to set the subform control Link Child and Link Master Fields to the name of the field or control that you wish to match. If you use the subform wizard, it will step you through the process. You may wish to set relationships in the relationship window, as well.