AnsweredAssumed Answered

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

Question asked by danny on Feb 27, 2014
Latest reply on Feb 28, 2014 by TSGal

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

Outcomes