Sum up quantities of another table?

830 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have two tables, one is the Inventory, another one is the Purchase History. I order the same products very frequently. I know I have to add a column to link to Purchase Inventory in Inventory table. How can I get a quantity SUM of the same product in the Inventory table without having to select every single purchase transaction in Inventory table, and have it update the SUM automatically?

0 Replies 0