Hi All,

 

Am I going crazy or is there no way to sort data displayed on a popup menu?

 

I have a popup menu that takes its data from a value list. The value list looks at a table in my FM solution and uses the ID field, also displays from the name field and has "show only values from second field" checked.

 

This gives me a great list. 

 

However, my client has asked for custom ordering - we have a new field in the table called "display order", my clients will go in and give each record in the table a numeric value and then want the popup list ordered by that rather than the default ordering.

 

Is this possible?!

 

Many thanks

Value lists based on field content are sourced from the field's index - and therefore always sorted alphabetically, numerically or chronologically (based on the field's type), in ascending order.

 

Consider an alternative selection method, e.g. from a portal or a list view.

you might look at this:  http://filemakerhacks.com/2013/11/22/its-sorta-a-value-list-thing/

 

I Have used something like this and had it work well.

 

hth,

Martie