Sort order of values on popup menu

[bruceiow]

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

[comment]

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.

[MartieH]

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