Removing a record

[aussieolie]

I have a form where I enter in purchase details, including the ID, when I enter these details into a sales table(which means the item has been sold). How can I get a query to lower the quanity value for the product in my inventory table, thus the system has lower quantity as they have been sold.

Thank you

Olie

 

[Fuga]

You could create a missmatch query, ie a query that selects the inventories that are not present in the "sold" table.

You can use the wizard for this.

Fuga.

 

[Rich]

Sum(qtyRcd)-Sum(qtySold)