I have the following tables:
Parts(PartID, Description)
SecondaryParts (SPartID, Description)
The relationship between the table is a 1:M - One part can have many secondary parts associated with it.
I want to create a Form that will allow me to select the PartID and When a PartID is selected, I would like all the SecondaryParts that are related to the PartID to automatically populate on the Form.
Software/Hardware used:
Access 2010
ASKED:
October 27, 2011 6:47 PM
UPDATED:
October 28, 2011 12:45 PM