Connecting tables

[FrankGrinds]

Hello AccessForum community,

I have a question regarding my Access 2010 database.

How can I connect my "Inventory" table to my "Sales" table so that every time that I enter the sale of a certain product, the "Inventory" table will update automatically to reflect the new stock amount?

Below are screen shots of my table relationships, the "Books", "Inventory", and "Sales" tables.

Thanks in advance for any help.



- Frank

[June7]

Review http://allenbrowne.com/AppInventory.html

[FrankGrinds]

Thank you.