Hi Chris
This is actually a fairly big question. The short answer is that Northwind
does not maintain this for you, so having the field in the table is probably
misleading.
In practice, there is no one-size-fits-all solution to this question. Some
databases such as fresh produce must handle batches of products and organize
for FIFO (first-in, first-out). Others (such as electrical goods), must
track individual items by serial number.
For an introduction to what's involved, see:
Inventory Control - Quantity On Hand
at:
http://members.iinet.net.au/~allenbr...Inventory.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Allen" <ZM*@nono.com > wrote in message
news:8A******** ******@twister. nyroc.rr.com...
Hi All,
Have been using access for some time on a limited basis.I was playing
around
with the Northwind database and I have a question for you all. I was
looking
at the Products form and it give details about products including how many
are in stock, I picked the product called Chai. By default is says that 39
units in stock. I then go to the orders form and create a new order and
use
say 5 , fill in all the fields and save the record. I go back to the
products form and it still says there are 39 in it and also checked the
products table and it also says 39. I guess my question is this, Is this
database suppose to be updating the in stock Inventory when a order is
filled,perhaps Iam missing somthing here being so new to this. thanks in
advance.
Chris