Replace external source table with local table?

[Jon Newton]

I am using an externally sourced table ("email") to fill a field in a local table ("person") using a secondary id.

I have copied that external table and imported it as a local table. Same data, just on my local drive.

I want to re-target the data in the person table to point to this new local version. I not quite clear on how to do it so that the data in each person record stays the same.

Any help would be appreciated!

[Jon Newton]

Well I guess I figured it out. The secondary ID is stored as a number in the person table, so I just repointed that relationship to the local email table and then fixed various aspects of the layout.