AnsweredAssumed Answered

Value list set to only show second value bug

Question asked by andytsg on Dec 14, 2013
Latest reply on Dec 17, 2013 by TSGal

Summary

Value list set to only show second value bug

Product

FileMaker Pro

Version

13.0 v1

Operating system version

windows 7

Description of the issue

A value list set to use values from one field and only display values from a second Number field does not display expected values. It seems to only show values 1, 2 and multiples of 10.

Steps to reproduce the problem

Create a value list with values from two fields, and display only the second one (must be a number field). Create 10 records in the referenced table with values 1 through 10 in both fields.

Expected result

To see all record values in the referenced table (1,2,3,4,5,6,7,8,9,10)

Actual result

Only a select few of the values display (1,2,10)

Exact text of any error message(s) that appear

N/A

Configuration information

The same value list operates as expected in FileMaker 12.

Workaround

If the number field is set to text all the values display. However they don't sort correctly so this isn't much of a workaround

Outcomes