Need Help to update field to New field from different table

Hi,

I have two tables;

Case Table (Case ID, User Name, Customer Name, Customer Address, Date)
Change Table (Case ID, Old User Name, New User Name)

I am trying to update “Case Table” with “New User Name” from “Change
Table” if Case Table. Case ID = Change Table.Case ID.

Thank you,
Sajan

Create a new query.
In the query designer, add both tables
Join the tables on CaseID
Select option 1 for the join type (where = in both table)
Select the fields you want to change in the Case table in the Fields row
enter the name of the corresponding fields in the Update to row from the
Change table.

--
Dave Hargis, Microsoft Access MVP


"Saz" wrote:

Hi,

I have two tables;

Case Table (Case ID, User Name, Customer Name, Customer Address, Date)
Change Table (Case ID, Old User Name, New User Name)

I am trying to update “Case Table� with “New User Name� from “Change
Table� if Case Table. Case ID = Change Table.Case ID.

Thank you,
Sajan

On Jul 15, 10:06*am, Klatuu wrote:
Create a new query.
In the query designer, add both tables
Join the tables on CaseID
Select option 1 for the join type (where = in both table)
Select the fields you want to change in the Case table in the Fields row
enter the name of the corresponding fields in the Update to row from the
Change table.

--
Dave Hargis, Microsoft Access MVP



"Saz" wrote:
Hi,

I have two tables;

Case Table (Case ID, User Name, Customer Name, Customer Address, Date)
Change Table (Case ID, Old User Name, New User Name)

I am trying to update “Case Table” with “New User Name” from “Change
Table” if Case Table. Case ID = Change Table.Case ID.

Thank you,
Sajan- Hide quoted text -

- Show quoted text -


Thank you Dave. I was using "Assigned to" in a wrong way.