Conditionnal value list with field based sorting

[El_Pablo]

This would be so cool, if FM could integrate this feature in the next version.

Simple as

CREATE VIEW vw_Distances AS

SELECT Distance

FROM lut_Distances

WHERE unit = "km"

ORDER BY viewOrder ASC

Most DBMS offer this possibility.

[Søren Dyhr]

So does filemaker, just pile up many instances of the same field, and let an event trigger deside which of the instances to go to, based on the circumstances. Each instance has obviously it's own popup sort order tied to it.

Admitted, would require some spit and polish from the developer.

--sd

[El_Pablo]

That's not an easy way! ;)

[Søren Dyhr]

Hence the spit and polish!

--sd

[Søren Dyhr]

While thinking a bit further of what you wish is the quirky bit that only hardwired valuelist keeps the original sort order, as soon as you stuff something pilcrow delimited into a field via an event trigged script on which the value is suppose to build upon will the list be using the same behaviour as ValueListItems( which sorts alfabetical and omitting duplicates if necessary.

--sd