MS Access Functionality Problem

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?

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your response...

Discuss This Question: &nbsp

There was an error processing your information. Please try again later.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your reply...

There was an error processing your information. Please try again later.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy