Bound primary autonumber ID field instead of "city" field and want to change ID to city name

[sleake]

Made the mistake of making the ID field the bound field and want to have the city name instead of the ID field written to the table. I've changed the bound field to 2. How would I go about designing a query to change the values instead of going through records and re-selecting the city?

[June7]

Create another field for the city name. Build a query that joins tables on the ID fields. Switch it to an UPDATE query, populate the new field. Delete the old field.

[sleake]

I have created the following update query using the new field City2, but am, of course, getting a type mismatch error because of the criteria, where I've tried to link a text field to a number field. Can you point me in the right direction?

[June7]

My instructions about the linking were not clear. The link should be on the tbl_List_City ID and its related foreign key field in tbl_Contacts which would be City field. Change City field to a number type if it actually has ID number data.

[sleake]

Thanks so much. That did the trick. Problem solved. I'll mark this solved.