Table and or Relationships problem

[JA]

Hello

I am trying to design a database to keep track of parts that are inspected;
whether they pass inspection or fail. So far I created the following tables
and an input form based on tblInsReport and two sub-forms - tblSerialNumber
and tblReject. However there is something wrong with this design because
when I set a query, the results are incorrect. if I set a query to display
the sum of quantity rejected (FailQty) and quantity passed (AcceptQty), the
result is the multiplication of the fields.



I would appreciate any help



Table Designs



tblInsReport

ReportNumber - Autonumber (PK)

WorkOrder

PartNumber

PartName

Sequence



tblReject

ItemNumber - Autonumber (PK)

ReportNumber (FK)

RejectSerialNumber

FailQty



tblSerialNo

ItemNumber - AutoNumber (PK)

ReportNumber (FK)

AcceptSerialNumber

AcceptQty



Relationships

One to many tblInsReport - tblReject based on ReportNumber

One to many tblInsReport - tblSerialNumber based on ReportNumber



Javier