Roland

[rghaddad@inco.com.lb]

Good morning,
I am currently working on a stock management database, where all my stock is stored in a table "Table_Stock"
This table was created and included the original stock quantities when I first created my database.
Today we are placing an order for new stock.
Should the existing Table_Stock table be updated with the new quantities?
Thanks in advance
Roland

 

[smig]

The best method for stock management is storing the stocks movements.
The stock is calculated based on the movements.