Look into last data

[JoeAcess]

Hi everyone

I have a form called stocks which contains many fields. there are 2 fields of interest, current stock, ordered stock.

Now suppose i have a material called pins, I would have entered the current stock and ordered stock. now suppose i want to enter the current stock later and the ordered stock, i would liked it be looked up on the last updated values using the date and name and call it into 2 fields called previously available stock and previously ordered stock. How do i do this?

 

[gemma-the-husky]

I would have entered the current stock and ordered stock.

i dont quite understand this, but this is not really the best way to go about stock

with stock, you should not store stock count information in the product record at all. You SHOULD have a stock movements table, storing all stock details, with the productid being an idenitifer in that table

now to evaluate the stock holding for any product you add all the transactions together. If necessary, you could have a "dead" flag on the stock record, at some point so that when you did a stock take, you could start from a new balance and "dead" the older records, to reduce the number of active transactions.

You would have to think about a mechanism for managing undelivered orders - but its a similar idea - select items from the order file - dont include the figures in the products record

hope this helps