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?
Sum up quantities of another table?
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.