Query In Access 2007

[hamxa7]

I am new to access... so i need your help designing a query...
I have made two tables , namely Shoe Order Table And Shoe Stock Table...
now what I want to do is , if I enter a value to a field (qty. demanded , to be precise) in Shoe Order Table.... The value automatically is added to a field (qty left) in the Shoe Stock Table...
.................................................................................................................
Plz use simple techniques as I am just an o-levels student
Reply Quickly....

 

[ssc456]

I've never been a big fan of access so i'm not sure on the exact way of doing this. But what you need to look into is Databse triggers and stored procedure.

What you will be doing here is creating a stored procedure which is in affect a stored query which is triggered upon update of your first table.

 

[hamxa7]

Thnx for your answer but I need a full step by step explanation on how to do this....!!!