7 Replies Latest reply on Aug 15, 2012 12:29 PM by MattGreger

    Value List Sorted by Second field will not display

    MattGreger

      Summary

      Value List Sorted by Second field will not display

      Product

      FileMaker Pro

      Version

      12v2

      Operating system version

      Windows & Mac

      Description of the issue

      If a value list is set to show 2 fields and either "Only show second field" or sort by second field is selected, value list will not load. If you use the "Include Arrow to Show/Hide List" it will force the value list to load. Once loaded it works. Even if I go to layout mode and uncheck the Include arrow, it will work since it seems to be loaded in memory.

      This is a specific issue in Find mode for sure and I also think in browse mode. Also specific to drop-down list.

      Steps to reproduce the problem

      Create a value list with 2 fields and set the sort to the second field or to only show values from second field.

      Assign value list to a field. Drop-Down list.

      Both fields are index, by the way. I tried rebuilding the indexes and did not fix the issue.

      Expected result

      Value list should display.

      Actual result

      Value list does not display until it's loaded into memory. Seems like if you use the "Include Arrow to Show/Hide List" it forces list into memory.

      Workaround

      Must use the option "Include Arrow to Show/Hide List"