2 Replies Latest reply on Jan 10, 2014 7:21 AM by TSGal

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

    Jade

      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