I have a pretty simple access database that I am working on that will be used as a point-of-sale system for a small store. I have three forms: Customers, SalesTransactions, and ProductInventory. In my product inventory form, I have each product listed individually, along with the quantity of this product that I have on hand (Quantity). In my sales transactions form, I have a column that shows which product has been sold, and another column (Quantity) that shows how many units of a specific product were sold. How can I link these two forms together, so that when I enter a quantity of a product sold in the SalesTransactions form, the quantity on hand for that product is automatically deducted from the correct product quantity row in the ProductInventory form?

Hi

Welcome to UtterAccess (IMG:style_emoticons/default/welcome2UA.gif)

The short answer is you don't. As with any relational database, it all starts with the correct table structure and setting things up properly (IMG:style_emoticons/default/wink.gif)

An inventory style database can be quite a challenging project. Have a look at Allen Brownes explanation of Quantity on Hand and to see the kind of structure you'd need.

Good luck with your project and you know where to come if/when you need a helping hand