Updating fields

[fordy]

Ive created a stock take database and want one field in a new record to be updated, when the previous one is filled in.

For example, when the stock quantity is known, I want the amount in stock to be added to the next months stock form.

Does anyone know how to do it.

 

[Rich]

This question comes up for discussion on numerous occasions, including very recently, use the search button at the top for Stock, you'll find a plethora of answers.

 

[fordy]

Ive looked and cant find anything relevant. All I need is a dlook up function, that looks up the result of a calculation in the last record. Can this be done

 

[Rich]

Next Month, do you keep tables,fields for each month?

 

[fordy]

Not tables, just records