Using a calculated field in a value list for a drop down list
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?
Make sure that your calculation field has "Text" selected as the result type. Often, a calculation will default to number and then the results look correct, but the data will not be correctly indexed for searches, sorts, relationships and this kind of value list.