Hi All,

I developed an inventory system, with a product table which records quantity in stock.

However, my friends told me yesterday that it is better to store InitialStock, and make a query to view available stock instead.

Which is best? What are the pros and cons?

Thank you!