Drop-down Box not updating first selected field
Operating system version
Description of the issue
I am trying to add a Drop-Down. I have a table that holds patient information and one of the fields in "Nurse"
I have another table called Nurses" with fields as follows NurseID, NurseName, Etc
from within a layout I wish to have a drop down list to select the patients nurse.
The Patients table stores the NurseID
The drop-down returns the ID number but shows the NurseName
I have tried all sorts of ways to configure it but I still don't get the result I want
I would like to be able to select the NursesName from (Nurse table)the drop down list and have it store the correct NurseId in the patient table.
It will works ok as a pop-up but when the list gets too long it will not be of any good to me
The Patient:NurseID has a relationship with the Nurse:NurseName
Any help would be great
Steps to reproduce the problem
changing every possible combination
up date the drop down list to update the value in the Patient table
showing the NurseID and not NurseName even when display second field is selected