Is this possible? Updating Multiple Records at once

[r3n]

Is this possible?
The scenario is this. I have the following:

UPDATES table
INVENTORY table.

I want to makes multiple changes on multiple records on the Inventory table. What I have done is created a form that has a datasheet view and represents the UPDATES table.

In the bottom is the Datasheet view of the INVENTORY table.

I want to update all changes on the UPDATES table to compare and edit changes on records that are Matching on the INVENTORY table. I am using a datasheet for both. And when I try to use an update query it only updates one matching record on the INVENTORY table not both.


All help is very appreciated!!!!

 

[KathyL]

This is tricky. Doing updates through a query having joined tables can be difficult unless you’re experienced with doing it. You have to understand inner and outer joins.
I would probably control all of this using VB code in the background. You don’t say if you’re going to do this manually all the time, or if you’re expecting to put a command button on your form which would execute the updates in the Inventory table.

For complicated updates, I have written Visual Basic code which will open one table (e.g. your updates table), and advance one record at a time, and loop through another bit of VB code which will handle updates to the secondary table for the group of related records in the secondary table.