Auto update in database when change quantity

[mrijet]

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?

[Seth Schrock]

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.