Hello,
I'm working on a simple database for inventory.
I have a form 'PurchaseOrder' with a subform' ' PurchaseOrderDetails'. In the subform you can chose multiple products in the same purchaseorder.
When I want to update the quantity from the subform with an UpdateQuery in to a table called "product' under ' Quantity in'.It only updates one row and not all the rows . Someone know whats going wrong?