-
Help with conceptualization
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.
-
A good starting point would be working through this tutorial
-
Thank you I will look into this.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules