Auto-Populate FK in table

[Justin Bailey]

hi, I'm relatively new to Access.
I have two tables. both from imported data.



Table1: ID, City, Customer FK [no data yet]

Table2: ID, Customer, City, City FK [no data yet]


The City field data in Table1 and Table2 are identical. Table2 had already came imported with data of customer/city relationship in two independent fields inside one table, is there a way to easily auto-populate the City FK in Table2 and have the corresponding Customer FK in Table1? then afterwards safely remove the redundant city field data in Table2 ? Would some kind of query or update method work for this task?

[Micron]

Equal join the two tables on City and update [City FK] with Table1.ID. I don't think you have to specify criteria (WHERE City in one table = City in the other) due to the equal join. Then you can go into table design and delete the City field. The thing is, what is the purpose of first table? If it's customers, the city fk should be there, not the city. If it's a city table, the customer fk should not be there. Wondering if you should research database normalization before going any farther.