1 Reply Latest reply on Dec 7, 2013 8:22 AM by philmodjunk

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

    DavidHazlebeck

      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