Automatic updating fields

[suevan]

I have a stock inventory data base. Main table of information with stock on hand field with links to stock issued and received. I wish to know how to create an action that will automatically updated the quantity of stock on hand by increasing it after "quantity received" and decreasing it after "stock issued". I am doing it manually at the moment and it is driving me crazy - time consuming. I hope someone can help.

 

[devious_dude]

The general approach that I would take may not necessarily be the best but......

I would create a transaction table recording receipts and issues with a 'PostedStatus' field set to yes/no.

It is then a simple matter of Balance = Balance + Unposted Receipts - Unposted Issues. Ensure that posting status of transaction is switched on updating the balance field.

 

[Rich]

http://www.access-programmers.co.uk/ubb/Forum1/HTML/007023.html