Make a lookup work for existing records
I have a small database of 66 records that groups records by doctor id number. There are about 10 doctors and I need to identify the doctors by name. I have created a new table with 2 fields , doctor id and doctor name, and created a relationship between the doctor id in the new and main tables. I then added a lookup field to the main table that gets the doctor name from the id. It works for new records , - how can I make it work for the existing records ?.
Is this the best way to do this ?.