AnsweredAssumed Answered

Using a calculated field in a value list for a drop down list

Question asked by DavidHazlebeck on Dec 6, 2013
Latest reply on Dec 7, 2013 by philmodjunk

Title

Using a calculated field in a value list for a drop down list

Post

     I am new  to Filemaker and building my first database.

     I have a table with information on staff (ID, names, address, etc).  

     The names are entered first, last, middle, and then a calculated field is used to display a full name

     In another table, I  have a field formatted as drop-down list to select a staff member associated with a particular record from a value list.  This first field in the value list is the staff member ID (a number), and the second field (only one displayed) is the name.  If I use a text field like the last name as the second field everything works fine.  If I try to use the calculated field so that the whole name displays, then the drop-down list just displays "?".  Is there anyway use the calculated field in the drop-down list?

     Thank you

     Dave

Outcomes