merging internal and external fields
I have a simple DB for which I'd like to merge two fields. One accesses an external file of names and over the years I'd choose the name from the drop down list. The other field was filled in manually when the external file did not include a name I needed. Is there a way to merge these two fields so that I can get rid of the external file but maintain the names in each record that was previously populating that field?