Update Stock Query

[spazzer]

Hi,
I have a table with called Transactions and a Table called Equipment, In the Transactions Table I have a field for number of items returned and a field for items taken, if I input 1 into items returned I would like the in stock field to add 1 to the instock field and if I enter 1 into the Items Taken field 1 will be subtracted from the in stock field.
I have about 20 items in stock so would like the stock for that item to be updated only ,can anyone tell me how to do this or advise please !!

Many Thanks,
Nick C

 

[pbaldy]

I wouldn't try to store the quantity on hand. There's a good discussion here, along with methods to do either.

 

[spazzer]

Hi,
Thanks for reply but I am a little mystified about the response, can you advise of an alternative method of acheiving this please !!!

All the Best,
Nick C

 

[pbaldy]

Sorry; forgot the link:

http://allenbrowne.com/AppInventory.html

 

[pbaldy]

I should add that in the inventory applications I've written, I just calculate the quantity on hand from transactions.