I have a simple database for tracking defects. On a given date and part number, I may have 10 different defects. Below are the two tables I have.
Header Table Detail Table
ID ID
Date Defect Type
Part Number...
I've put together a very simple database to collect defect information. It only has two tables that are linked together. The Header table is made up of ID, Motor No, Date, and Total Packed fields. The detail is made up of ID, defect, and Qty fields. They are linked by the ID fields.
What...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.