AnsweredAssumed Answered

Value List Sorted by Second field will not display

Question asked by MattGreger on Aug 14, 2012
Latest reply on Aug 15, 2012 by 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"

Outcomes