L
luser error
Hello,
I have three linked tables: Supplier, Product, Supplier Order
I have a supplier order form, in there I select a Supplier ID (from Supplier
Table) and a Product ID (from Product Table). Also there is a manually filled
in quantity field. When I populate that field I want to click onto a command
button that adds the quantity onto the Stock Qunatity field (from Product
Table) whislt saving the record in the Supplier Order table as normal. I
pretty sure it's an update query that must be linked through a macro, but
after many attempts I need the answer please.
Thanks,
I have three linked tables: Supplier, Product, Supplier Order
I have a supplier order form, in there I select a Supplier ID (from Supplier
Table) and a Product ID (from Product Table). Also there is a manually filled
in quantity field. When I populate that field I want to click onto a command
button that adds the quantity onto the Stock Qunatity field (from Product
Table) whislt saving the record in the Supplier Order table as normal. I
pretty sure it's an update query that must be linked through a macro, but
after many attempts I need the answer please.
Thanks,