Sort Value List Numbers in Descending Order

[Corey-Troy]

I am using a List of Numbers in a field on layout 1 from Table2.

The values are populated from another field table in Table1.

The Table1 values are Sorted in Descending order such as:

7003

7002

7001

7000

etc...

But when i click on the field in Table2 to view the value list items from Table1, they are sorted as:

7000

7001

7002

7003

etc..

Is it possible to re-sort them in Descending order instead in the Value List?

If so, how?

Corey....

[Makah]

Have you tried sorting the records in the Edit Relationship dialog in Manage Database? That should work.

[comment]

I don't think so - value list items are always sorted in ascending order. If your list is fairly small, you could use the workaround described here:

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

[Corey-Troy]

The list will start small, but will be rather long in time(1000's).

As is the user will have to keep scrolling all the way down to the last values each time.

Would there be a way to look at somehow having the used(used values)no longer display to keep the list smaller?

How would i use a calculation in a related field like this though?

Something like:

Case(Table2::FieldB=Table1::FieldA;Do not display in Value List

Edited December 13, 2009 by Guest

[capisco]

I, too, have wondered about the sorting of Value Lists.

There seem to be multiple opportunities to spec sorting (at the Define Relationship level, at the Define Portal level, and at Define Value List level [especially 1st vs. 2nd field]), but I'm unclear which takes precedence, and sometimes unsure why results aren't as predicted or why there's the potential for contradiction.

Any comments or insight is appreciated.

Edited January 26, 2010 by Guest