AnsweredAssumed Answered

Drop-down Box not updating first selected field

Question asked by GregoryMcLean on Mar 28, 2011
Latest reply on Mar 29, 2011 by philmodjunk


Drop-down Box not updating first selected field


FileMaker Pro


11 Advanced

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

Thank you

Steps to reproduce the problem

changing every possible combination

Expected result

up date the drop down list to update the value in the Patient table

Actual result

showing the NurseID and not NurseName even when display second field is selected