Need Help to update field to New field from different table

[Saz]

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

 

[Klatuu]

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.

 

[Saz]

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









- Show quoted text -

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