I have been trying to make the first append query:
Code:
INSERT INTO PurchaseOrder ( PurchaseOrderID, fkSupplierID, PurchaseOrderNumber )
SELECT PurchaseOrderDetails.fkPurchaseOrderID, PurchaseOrder.fkSupplierID, DMax("PurchaseOrderNumber","PurchaseOrder")+1 AS PurchaseOrderNumber
FROM PurchaseOrder INNER JOIN PurchaseOrderDetails ON PurchaseOrder.PurchaseOrderID = PurchaseOrderDetails.fkPurchaseOrderID
WHERE (((PurchaseOrder.fkSupplierID) Like "*" & [Forms]![SupplierBoxForm]![CboSupplier] & "*"));
I made a small form called SupplierBoxForm where I can select the supplier, then I made a button to run the above mentioned Append query. unfortunately It doesn't add any new records to the table PurchaseOrders. My table fields are:
PurchaseOrderID (Primary Key), PurchaseOrderNumber, fkSupplierID, fkEmployeeID, PaymentMethod, and PONotes , then the PurchaseOrderDetails table contains:ID (Primary Key) autonumber, fkPurchaseOrderID, fkProductID, PODate,QtyOrdered, OurCost, RecivedDate. The two tables are joined by PurchaseOrderID(PurchaseOrder Table) to fkPurchaseOrderID (purchaseOrderDetails Table).What am I doing wrong?? Thanks for your help