Connect two table

Hi,

I have two tables call "Stock and InStock"- Access Database.

In "Stock" There is a field call Stock In Hand and in "InStock" there is a field call quantity - How to write a code to connect the "quantity" in "InStock table" to the "Stock In Hand" in the "Stock table". There's mean when I update or add record in the "Quantity - InStock Table" the "Stock In Hand - Stock Table" will automatically updated.

eg

Stock table
Id = 1
Stock In Hand = 20

InStock Table
Id = 1
add in Quantity = 10 then
Stock table
Stock In hand will become 30





Thanx
By Loh

In Access Help.

Check out Queries and Joins.

Use the solutions and northwind sample Dbs to help aswell.