Help with conceptualization

[Mwhiterabbbit]

Hello,

I am trying to build a database for QA samples. The database is to hold the product code, dates, who tested it, and product count. All that is simple enough but I want to be able to add measurements of the packaged product, such as length and weight. How do I tie in together 70 something measurements of length and weight to the current information?

I don't know if I should keep the length and weight on the same table or a different one. If they were on the same table I don't know how to record the data accuratly as I can't figure out how to make more than 1 individual products weight and length at a time.

Here is a list of things I want to record.


Date/time - date
SKU - number
Tester Name - text
Case Code - text
Amount of Product in case - number
Product Length - number
Product Weight -number

The form I am going to use has inputs for the conventional entries and then 80 possible entries for length and widths.

Thank you for your help.

[orange]

A good starting point would be working through this tutorial

[Mwhiterabbbit]

Thank you I will look into this.