AnsweredAssumed Answered

Drop-down does not display all numeric values from value list's second numeric field

Question asked by Jade on Jan 10, 2014
Latest reply on Jan 10, 2014 by TSGal

Summary

Drop-down does not display all numeric values from value list's second numeric field

Product

FileMaker Pro

Version

FMPA 13.0.1

Operating system version

OS X 10.9.2

Description of the issue

When a value list displays only a numeric second field in either a drop-down or pop-up related field, only some of the numeric values are displayed.

In the attached example, the numeric field contains the values: 1, 2, 3, 4, 5, 6, 20, 21, 22, 31, 32
but the value list on a related table field shows only: 1, 2, 20, 31, "   ", "   "

This works correctly in FMPA 12.0.5.
This works correctly if both the primary key and the secondary numeric field are displayed.
This works correctly if the secondary only field is text not number.

This does not work if the secondary only field is number.

Steps to reproduce the problem

Add two tables: Frequency, Radio
Add two fields to Frequency: pk_ID, Channel where pk_ID is serial auto increment and Channel is a number field with the values: 1, 2, 3, 4, 5, etc.
Add two fields to Radio: pk_ID, fk_ID
Relate Frequency::pk_ID = Radio::fk_ID
Add a Value List: Frequency using values from Frequency::pk_ID and second field Frequency::Channel (Show values only from the second field)
Create a layout based on Radio with a drop-down field on fk_ID using the value list Frequency.

Expected result

The drop-down list should show the values of Frequency::Channel
1, 2, 3, 4, 5, etc.

Actual result

The drop-down list shows 1, 2, 20, 31

Exact text of any error message(s) that appear

none

Workaround

Show a calculated text field = Right("    " & Frequency::Channel ; 4 ) instead of a number field

Value_List.jpg

Outcomes