Updating fields in a table when a new record is entered to another table.

  • Thread starter Thread starter Scott McDaniel
  • Start date Start date
S

Scott McDaniel

You really should not store your QuantityOnHand. A traditional approach is
to have a starting point (for example, a physical inventory count) from
which you subtract all items which have been sold/transferred/etc from that
point. You may also have more "starting points" (for example, if you do a
yearly physical inventory, you may wish to adjust your stockcount and use
that number instead), or you may have only ONE starting point, from which
you subtract ALL item events (sales, thefts, damage, etc etc) to determine
final stock count etc etc.

Allen Browne is much more knowledgable than I on this, and has written a
good article regarding this:

http://users.bigpond.net.au/abrowne1/AppInventory.html
 
Scott, if you could the link redirects to an unavailable page.

If you could, please write the link again.

Thanks
 
The two tables that concern this prblem of mine is Ordered_Products and
Products table. In the products table, there is a field called
current_stock. In Ordered_Products, the user will enter a number in a field
called quantity. what I want to do is, I want Access to automatically update
the current stock in the Products table with the new amount; ie;
Current_Stock = Current_Stock - Quantity, whenever a user enters a new
record in the Ordered_ Products table.

Thank you
Daniel Yahya
 
Back
Top