Value list showing only second field when second field is numeric does not show all values.
Operating system version
Mac OS 10.9.1
Description of the issue
Value list set to show only the second field does not show all values when the second field is numeric.
Steps to reproduce the problem
Create a table with an ID field and a number field. Create a value list to list the ID field and show the number field as the second field. Select to show only the second field.
Value list will contain a list of all values in the number field. This is the result in FMP 12.
Value list only shows a subset of the values.
Create a calculation field with the value of the number field. Set the calculation to show value as text. Use the calculation in the value list instead of the number field. However, it will sort alphabetically, not numerically.