Reply to thread

Message: [QUOTE="Sgwapt, post: 2572253"] Craig, Thank you for your assistance. This is about what I am looking for. One table that contains the equipment list Another table that contains the repair details The subform i have played with looking at the sample db in help. What i done in Excel is to create a list of part numbers (Products) when the user selects the tool number (EqId). This way the users cannot select or enter a part number against a repair (EqId) that does not belong to that tool number. Now I want to do this in Access but cannot seem to find the correct method to make this list. Some tools have multiple products and some only have one. Any thoughts will be helpful Thanks [/QUOTE]