Originally Posted by
June7
There is no need for both ProductID and Barcode in tblSalesDetails and tblPurchaseDetails. ProductID can probably be eliminated from all 3 tables.
I see tblPONum is now not in relationship with tblPurchases.
The Purchases form/subform appears to be working. However, really don't need to show the ID and PONum in the subform. If you do, at least make them Locked Yes and TabStop No.
The ProductID combobox properties need to be changed:
ControlSource: Barcode
RowSource: SELECT tblProducts.Barcode, tblProducts.ProductDesc FROM tblProducts ORDER BY tblProducts.ProductDesc;
ColumnCount: 2
ColumnWidths: 0";2.0"