Update Inventory

[Melissa]

Products appear on multiple orders in a batch of orders. I created a totals
query with the fields, ProductID and SumOfQuantity. I have a TblProduct table of
products with the fields ProductID, Inventory, and other fields not relevant
here. My intent was to join the query and the table on the ProductID fields in
an update query to update Inventory by [Inventory] - [SumOfQuantity]. The update
query turned out to be not updateable.

I need ideas on another approach to update inventory from sales on multiple
orders.

Thanks!

Melissa

[Allen Browne]

For an introductory discussion of this big question, see:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Melissa" <mw*****@earthlink.net> wrote in message
news:QA*****************@newsread1.news.atl.earthl ink.net...

Products appear on multiple orders in a batch of orders. I created a totals query with the fields, ProductID and SumOfQuantity. I have a TblProduct table of products with the fields ProductID, Inventory, and other fields not relevant here. My intent was to join the query and the table on the ProductID fields in an update query to update Inventory by [Inventory] - [SumOfQuantity]. The update query turned out to be not updateable.

I need ideas on another approach to update inventory from sales on multiple orders.