Update data in another table

[acrowe97]

I have a table that has a first and last name, phone number with extension, as well as another phone and extension. I have another table with first and last names, as well as fields with the same names and need to transfer this info to the other table. I know a query would do the trick, I just don't know how to set it up. I need kind of like a VLOOKUP-type update style (matching fields and updating certain info attached to those fields). Please advise, thanks!

[ranman256]

make a query, bring in both tables,
join the fields: FIRST, LAST.
change the query to UPDATE
bring down the fields you want to update onto the grid
in the UPDATE TO row , put what you want to change it to. Like:

(field) tClient.Phone
(update to) tTemp.Phone

[isladogs]

One word of warning.
If you have several people with the same first and Last names, the data could be incorrectly updated doing what Ranman suggested.
For example the data for one John Smith could get muddled with another.

That's why Access uses primary key fields so each record can be uniquely identified.
Instead join the two tables by the primary key fields in the update query

[acrowe97]

The only issue I think I'd have with that is the data is related through other tables. From Tenants>Leases>Suites>Permissions; Tenants (main contact info) and Permissions (employees of main contact) both have the same info on them, and the main contact info needs to be added to Permissions. Will this affect how the operation occurs?

[isladogs]

Do the two tables have a matching PK field e.g. ID?
If so, then you'll have no problems.

If not, then you can't do the update without a risk of data being muddled for those with identical names.
So in that case I would strongly recommend you sort out a matching PK field first