Hi All,
I set up a table to track defective parts on a shift-by-shift basis. The fields are: Entry Number (primary key auto number), Defect, Quantity, Inspector, Date, Shift, etc...
If someone inspects 1000 parts on day shift where 2 parts are found defective for rust and 1 is defective for...