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

stock updates coding

P: 1
I want to achieve distribution logic through ms access queries. The requirement is when i create the distribution record which stores the qty to be distributed it has to simultaneously while saving the record update 2 other tables the despatch tables depatch qty and the inventory tables excess stock qty. Cause these updated values are required the next. Had it been MS SQL i would have written the table level triggers. I need an equivalent solution in MS Access. Thanks.
Dec 19 '11 #1
Share this Question
Share on Google+
1 Reply


Narender Sagar
100+
P: 189
Yes Devika, you can do this in MS Access also. I can give you little bit idea. You can write some code in "After Update" event of your form.
You can search for this help on Bytes and will find lot of clues to achieve this.
Dec 19 '11 #2

Post your reply

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