AnsweredAssumed Answered

Make a lookup work for existing records

Question asked by nickphillips on Jul 16, 2014
Latest reply on Jul 16, 2014 by nickphillips


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