I have a purchase order table with product quantities and a separate table for inventory, when I click on a button that receives the purchase order, I want the 'Qty' mentioned in the purchase order table to be added with the 'qty' in inventory table for that specific product.
Eg:
- I have an inventory table with 100 apples into.
- I have another purchase order table with a purchase order for 50 apples.
- I click on the row of Purchase Order Table that has 50 the apples and mark it as received.
- Status of the purchase order changes to received.
- I want the inventory table to automatically change the qty of apples to 150
Done upto 1-4, dont know what to do for that final step.
I currently have a function in-place that marks the order as received.
Any help is appreciated on the query!