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

NORTHWIND questions

P: n/a
Hi everyone
I am new to this and have tried to customize the northwind.mdb to my
company. My problem is that after an order is written the number of
items in stock does not get automatically updated i.e I have 6 pcs of
product a in stock and reorder level set at 2. I write an order for say
5 pieces of the item. Shouldn't I get a warning telling me that my
reorder level has been reached and update my product list units in stock
so after 5 are sold I am left with one? Is there a macro I need to run
so I can update my items in stock and get a list of items for which the
re-order level has been reached?
Thanks in advance
Silas The Sailor
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Northwind does not even try to update the quantity on hand.

Inventory tracking is a big question, and there is no simple answer.
For an introduction to the issues involved, see:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.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.

"SilasTheSailor" <si************@operamail.com> wrote in message
news:cc**********@usenet.otenet.gr...
Hi everyone
I am new to this and have tried to customize the northwind.mdb to my
company. My problem is that after an order is written the number of
items in stock does not get automatically updated i.e I have 6 pcs of
product a in stock and reorder level set at 2. I write an order for say
5 pieces of the item. Shouldn't I get a warning telling me that my
reorder level has been reached and update my product list units in stock
so after 5 are sold I am left with one? Is there a macro I need to run
so I can update my items in stock and get a list of items for which the
re-order level has been reached?
Thanks in advance
Silas The Sailor

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.