Drop-down does not display all numeric values from value list's second numeric field
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.
The drop-down list should show the values of Frequency::Channel
1, 2, 3, 4, 5, etc.
The drop-down list shows 1, 2, 20, 31
Exact text of any error message(s) that appear
Show a calculated text field = Right(" " & Frequency::Channel ; 4 ) instead of a number field