Many-to-many form/subform

[ChacDB]

Somewhat novice user and need help:
Scenario: We have a process that involves making a Base Material that can be a single or multi-Step process and at each step in the process, multiple Components can be used. The BaseMaterial can then be used to make a Product that will ultimately be used to assemble the final Product. So I set up 5 tables, tblBaseMaterial, tblMaterialStep, tblStepComponents, tblParts and one for the tblProductAssembly. Now, I'm trying to create data entry forms for users. So I thought to start with a tabbed form with Base Material as the main form and a form/subform for the Step/Components where the user could use each tab for each step as needed, but when I try to do that the second tab is already populted with the first entry. How do I requery/refresh for a new Step/Component combination?

[June7]

Doesn't sound like normalized data structure. Would you like to provide project for analysis? The Attachment Manager is below the Advanced post editor. Copy, remove confidential data, run Compact & Repair, zip if still large.