stock management- closing stock and opening stock
I am trying to create a stock management system. I have created a table with the following fields
ProductID, Date,Product name, opening stock, Purchase, desptches, closing stck.
Now my problem is how do I make the closing stock of the previous day or record be automatically transfered as the opening stock of the current day or record