Complicated question based on a personal project, but if there was any thoughts or tips would be much appreciated

Hi, I am having troubles with a Personal Project that I am working on.

I am trying to develop a QC Testing Database for my work.

There are a number of different products we produce, and they each have a set of tests that have to be performed on a production Lot.

The database would have a form for the Test Report that would allow a user to go in and select the product they are testing. Ideally that would have a sub form that shows all the tests they have to perform, and then a box to enter in the results of each test. The operator could then and make a QC Test report that can be saved as a pdf.

**My biggest issue is creating a form to enter in new data.** I want the specific tests to show up based on the product they choose, and then be able to enter results tied to those tests.


I am able to enter in data into the tables manually, and make a form to view the data properly for each report.


As for tables I have:

Product table - unique table of all the products

Specification Tests table- unique table of all individual tests that have to be performed

Spec table - table that joins the product ID to all the specification tests that have to be performed

Report Table - table that creates a record for each report. This has

Result table - houses each unique test result. Relates to specification test ID as well as the Report ID.

As for queries, I have:

Query that shows the specification tests required based on the product ID chosen.