3 Replies Latest reply on Feb 28, 2014 6:43 AM by TSGal

    Value list showing only second field when second field is numeric does not show all values.

    danny

      Summary

      Value list showing only second field when second field is numeric does not show all values.

      Product

      FileMaker Pro

      Version

      13.0v1

      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.

      Expected result

      Value list will contain a list of all values in the number field. This is the result in FMP 12.

      Actual result

      Value list only shows a subset of the values.

      Workaround

      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.

      valueListBug.png