I am currently writing an Access 2003 database for tracking patient scores on various tests. I have a Patients table and a Test table where each record in the Test table has a "patientid" which is a foreign key back to the Patients table.
I am writing the data entry screen for the Test table, but I would like to display some additional information in that form about the patient (full name, ID, DOB, etc). I was thinking I could use expressions to take the patientid from the current Test record, look up the corresponding Patient record, then return the name. Problem is, I don't know how to "look up" values like this in the Expression Builder. So far, all I have is something like this:
But all that returns is "#Name?". How do I get it to look up the value for the correct record?