So i am creating a on hand inventory list page form (that will be used for viewing the products that are in stock) the on hand inventory will change based on the transactions that were entered in the inventory transactions form (that uses the inventory transactions table) like if a transaction is of type purchase the on hand inventory for that product should increase if a transaction is of type sale the onhand inventory for that product should decrease
So my question is that would i need to create a new table that will get populated automatically based on the transactions made in the inventory transactions table or is there any other way too?