Amending a number in 1 table with info from another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subtracting one field total from a second field 1
copy field data to a socond field 2
update a table from a form 1
decrementing numbers in inventory table 2
About dummy values for a tables 2
HELP: how do you get a query to add properly 4
Stocking Report help 4
Writing back to table 1

Back
Top