G
Guest
Hi, I am desperate for some help.
I have 2 tables: Inventory and Acquisitions. Each has ProductName, Size, and
Quantity fields that correspond (Product Name and Size are keys from one to
the other table). Basically, what I want to do is designate a quantity in
Acquisitions that reduces the quantity level in Inventory. (That is, this is
an Inventory list for a food pantry. If I have 5 loaves of bread in
Inventory, and I give 2 of them away in Acquisitions to a client, I want the
resulting Quantity in Inventory to reflect that I now only have 3 loaves of
bread.)
I have tried using an Update Query for this, but the way it is working now,
the query updates all of my records in Iventory, even ones that do not appear
in Acquisitions. It reduces the Quantity in Inventory properly for the items
it finds in Acquisitions, but it clears all Quantity information for all
other records in Inventory.
I have 2 tables: Inventory and Acquisitions. Each has ProductName, Size, and
Quantity fields that correspond (Product Name and Size are keys from one to
the other table). Basically, what I want to do is designate a quantity in
Acquisitions that reduces the quantity level in Inventory. (That is, this is
an Inventory list for a food pantry. If I have 5 loaves of bread in
Inventory, and I give 2 of them away in Acquisitions to a client, I want the
resulting Quantity in Inventory to reflect that I now only have 3 loaves of
bread.)
I have tried using an Update Query for this, but the way it is working now,
the query updates all of my records in Iventory, even ones that do not appear
in Acquisitions. It reduces the Quantity in Inventory properly for the items
it finds in Acquisitions, but it clears all Quantity information for all
other records in Inventory.