I have a table with an associated form listing all of our raw materials that we have in house (sometimes multiple lots of materials).
I have a table with an associated form defining the components (raw materials) of all of our products I have a “Build” table with which we would use a form to document the lot number of the product, the product line, batch size, etc.
The Build form has a subform which details the build in terms of raw material lots numbers used. What I need is for the subform to automatically populate with raw materials associated with the product being built once it is selected in the main form.
Then I can set it up so users can click a dropdown box for each material and document which lot number was used. The whole auto-population thing is the crux. If there’s 10 components to the product, I want to see 10 items listed in the subform as soon as I choose that product.
Note: This is not the same as a cascading drop box. I want the list to populate to avoid mistakes caused by forgetting about a component material. Any idea how I could do this?
Thanks for any help!!! Brian