By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,658 Members | 1,255 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,658 IT Pros & Developers. It's quick & easy.

A question about Northwind traders Database

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.