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

understanding North Wind Stock control

P: n/a
In the sample northwind database when an order is sent the sent value
come of the instock value. I can not work out how they have done this .
I can see that it is an eventprocedure but can not understand it or
relate it to my data base.
I want to be able to say that some thing has been shipped in a sales
table and deduct the value from the instock value in my products table.

Nov 23 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
There is a field in the Products table for the number of units in stock, but
(without testing) I suspect that the database does not even try to keep this
value up to date. Did you have a specific event procedure in mind?

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

"peter" <se*****@dancosgrove.co.nz> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
In the sample northwind database when an order is sent the sent value
come of the instock value. I can not work out how they have done this .
I can see that it is an eventprocedure but can not understand it or
relate it to my data base.
I want to be able to say that some thing has been shipped in a sales
table and deduct the value from the instock value in my products table.

Nov 23 '05 #2

P: n/a
Thank for the reply Allen
I have a table "Stock" that has feilds instock ,on consignment, on
order and sold feilds.
I have another table to record sales.
when a product is sold and entered into the sales table I want the
quanty sold to be deducted from the instock feild of the Stock table.
I have used alpha 5 and they use a thing called posting that you can
use an event 'on change' in the feild and tell it to deduct the amount
from a feild in another table. This is what I want to do.
I think that I have made a mistake it is not done in the northwind
database. it is in a inventory control data base that i got from the
sample data bases with access.

Nov 23 '05 #3

P: n/a
Hi Peter

Access forms have events you can use to respond to an entry. The AfterUpdate
event of the *form* responds to any new entry or change, and AfterDelConfirm
responds to a deletion.

However, there is more to it than that. For a discussion of the basics, see:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.html

For a detailed information, I suggest you buy "Building Access Applications"
by John Viescas (Microsoft Press, 2005.) The CD that accompanies the book
includes a database that assigns stock for orders, handling partial orders,
back orders, reversals and so on. It's incredibly good value if you are
getting the application for hte price of the book, and excellent
documentation (the book) thrown in.

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

"peter" <se*****@dancosgrove.co.nz> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
Thank for the reply Allen
I have a table "Stock" that has feilds instock ,on consignment, on
order and sold feilds.
I have another table to record sales.
when a product is sold and entered into the sales table I want the
quanty sold to be deducted from the instock feild of the Stock table.
I have used alpha 5 and they use a thing called posting that you can
use an event 'on change' in the feild and tell it to deduct the amount
from a feild in another table. This is what I want to do.
I think that I have made a mistake it is not done in the northwind
database. it is in a inventory control data base that i got from the
sample data bases with access.

Nov 23 '05 #4

P: n/a
Thanks Allen
I will try to find the book in new Zealand

Nov 28 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.