Sorting Value Lists

[Kris M]

Is it possible to override the sort order for a two field value list derived from values in a table where second value only displayed?

I noticed that if i have

table 1

pk field 2

1 Alpha

2 Bravo

3 Charlie

4 Delta

and i make a value list from the values in table 1 field 2 and use the value list as the source for a drop down the choices available are always sorted from A to Z.

I want to see the list in the drop down as

Delta

Bravo

Charlie

Alpha or some order other than a b c d.

Any thoughts?

TIA

Kris

[Vaughan]

No.

One option is to allow selection from a portal instead of a list or menu, and specify the sort order of the replationship.

[comment]

Here is a somewhat limited workaround:

http://www.fmforums.com/forum/showtopic.php?tid/184044/post/237956/#237956

[Kris M]

Interesting and would deffinately work if i didnt need the first field referenced in the list to contain the pk from the table.

I kind of thought id need some other kind of way to do this than a value list / drop down. It would certainly make life easier if the value list could be sorted easy but that is life.

Now if FMP could have a native hierarchical grid control... sorry caught mysenf dreaming...

Thanks for the input guys.

K

[comment]

If the values are more or less constant, perhaps you could re-import them in the desired order and renumber them, then sort your VL by the new pk. Of course you would also need to replace any fk's referencing the pk, so it's a very delicate operation.