Hi everyone, I need help with adding a number from one table to another table.
This is a simple scenario, I'll give you an example for my requirement.
I have 2 tables. Inventory and Incoming Products
Inventory : Shows the quantity of items in stock.
Incoming Product : Shows the quantity of incoming products.
When I select a row from Incoming Products table and mark it as "Received" using a button, I want the product count in Inventory table to be increased by the amount (by matching the ItemID)
I'm quite new to platform and learning as I go, I currently have included a status column to Incoming Products table and managed to mark it as received. Not quite sure how to go about with adding the two values up in the main Inventory table.
A detailed explanation will be greatly helpful and appreciated.