Drop down menus
I've related a Patient ID to the Record table. On the record table I have a drop-down for the foreign key populated by a value list of Patietn ID & Patient Name, showing only 2nd field.
Problem: The dd only shows the current ID number and a "?". Eg. "2?"
What have I missed?