I have not worked with Access for several years and now need to create a parts inventory for my company. I'm going to use the Northwind database and strip down what is not applicable to us (which I have done). The problem I see is that in the Northwind database, the quantity in stock field in the products table does not seem to decrease when an order is placed. This is one of the main features that I need. Have I missed something? Can anyone tell me how to make this work? Any help would be appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Northwind sample database 1
- Thread starter Pupr
- Start date
-
1
- #2
ZmrAbdulla
Technical User
Reading Allen Browne's write up on this may be useful
________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.
________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.
- Status
Similar threads
- Locked
- Question