4 Replies Latest reply on Jul 16, 2014 8:49 AM by nickphillips

    Make a lookup work for existing records

    nickphillips

      Title

      Make a lookup work for existing records

      Post

           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 ?.