FMP 7, Mac OS X:

I am trying to create a value list that is made from field "source" in table "a", which is then sorted according to field "sort order" also in table "a".

I have created a self-join relationship "SELF_CONSTANT" from a global field "gCONSTANT" in table "A" that relates to "CONSTANT" field in table "A" and ensure that gCONSTANT has the same value as CONSTANT in all the records. The relationship has BOTH "Sort records" checkboxes checked and "sort order" field selected as to how to sort. Then the value list is created from he field "SELF_CONSTANT::source". Most curious is that a resulting popup menu using this value list has the values from "source" field sorted, but in alpha order, not sorted based on "sort order"!

Any thoughts whether i am off base? Ideas about how to do what i want in another way? Or is it possibly a bug in FMP 7.03?

TIA,

Isis

Value lists are not sorted according to the relationship sort order. They are always sorted alphabetically (by selected language) if they are based on text fields, or according to their data type (number, date, time etc).

Only custom value lists have user-defined item order. They appear in the order the values are typed.

This is not a bug.

Thank you! Wish that kind of thing was in the manual. I actually looked.

Peace,

Isis