I am building an Access 2016 database with two different tables. The first table has a list of patients and doctors, procedures and cost, etc. The doctors on the list are represented by a number instead of their name. Say "1," or "35."
I have another table that has what is essentially a key for that information. In the first column I have those numbers and in the second column I have the names of the doctors to which each number represents. So Column one says "1" and Column 2 says "Dr Jones, MD."
In Microsoft Access, how do I force the database to display the names instead of the doctor using the second table? RIght now the query comes up with the field for doctor and shows the numbers. I need the database to say "Oh, the doctor field is listed as 1 so therefore it is actually Dr Jones," and display that. I'm sure it has something to do with dependencies or relationships but I'm not sure what to do. I can provide an example, if necessary.