Sum up quantities of another table?


#1

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?