Amending a number in 1 table with info from another table

K

Kevin

I have set up a stock table, 1 of the fields is qtyinstock. From a sumbform
in another form, is it possiable to adjust the field. In other words, reduce
the qtyinstock from the stock form by using a field qtyused in another form,
and if so can you point me in the right direction and also do i do it from
the property of the qtyused or do i us the afterupdate and go to the Visual
basic code and complete the caculation from withing there
 
S

Steve Schapel

Kevin,

The usual way to handle this would be to delete the qtyinstock field
from the stock table. This is a derived value, and as such does not
need to be stored. You can calculate it, either via a query, or via a
calculated control on your form or report, whenever you need it. In the
meantime, save you a lot of bother.

There is an excellent discussion of this topic at
http://www.allenbrowne.com/AppInventory.html
 
Top