Ouch, you actually manually bump each defect for each product as you enter them? For example, it looks like you have this record:
Product Defect 1 Defect 2
ABC 0 0
Then if Defect 1 is reported, you do this to the same record:
Product Defect 1 Defect 2
ABC 1 0
Then if another Defect 1 is reported, you do this to the same record:
Product Defect 1 Defect 2
ABC 2 0
If this is correct, you are never going to get these defects reported by dates. Ever. Where are you storing dates on defects?
You should have a product look up table, a defect look up table, and then a Defect Reporting junction table. This last table would store your dates as you recorded defects, and you would have one record for each defect report. You could also add more data to the defect report this way.
This is basically what you need, if I understand your problem:
tblProduct
PK
ProductName
tblDefect
PK
DefectName
tblDefectReport
PK
FK tblProduct
FK tblDefect
ReportDate
FK tblClient (or reporting entity)
Comments
mmcdonal
|
