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!
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!
