understanding North Wind Stock control

[peter]

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.

[Allen Browne]

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.

[peter]

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.

[Allen Browne]

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.

[peter]

Thanks Allen
I will try to find the book in new Zealand