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

Auto update in database when change quantity

P: 64
Hello....Can I ask something...

It's that possible for Microsoft Access to auto deduct the quantity from database if user change the quantity..

For example...they are consist of 2 table in database

first table is Products and the field is stock
second table is Orders and the field is quantity needs

So, it's that any possibility for Microsoft Access to auto deduct and update in the table Products in stock field if I put the quantity needs..

Is there any possibilities for Microsoft Access to do that?
Apr 8 '15 #1
Share this Question
Share on Google+
1 Reply

Seth Schrock
Expert 2.5K+
P: 2,951
It is very possible, however, it is a very broad topic and how to do it depends on your specific needs. Try looking at the Northwind sample database that Microsoft provides. They have this functionality already built in. Look at how they do it and then try to do the same for yours. If you get stuck on an area, just post back here and we can help.
Apr 8 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.