Value list from field in descending order?

[Mauricio]

Is it possible to make a value list from a field to show in descending order?

This is to show the last serial number generated instead of the first at the beggining not at the far long end of a value list.

Help appreciated.

Mauricio

Platform: G5 / Version: OSX

FileMaker Version: FM6

Platform: / Version:

FileMaker Version:

Platform: / Version:

FileMaker Version:

[Mandu]

I was just looking for an answer to this very question, so I'll just bump it. My second field (the one I want to sort into descending sequence) is a text field that begins with a date in YYYY/MM/DD format.

Doesn't look too promising - any ideas, anyone?

Thanks,

Chap

[Edit: oops, I see that Mauricio is using FMP 7. I'm using FMP 6.]

[Ender]

Unfortunately, you cannot sort a value list in decending order.

You might try using a portal to make the selection instead of a value list.

[-Queue-]

Well, you can, to an extent. But it's really tricky and more of a pita than it might be worth. A portal would be a much easier solution.

[Mandu]

Thanks for confirming my suspicions - it isn't worth it, really. :-)

Chap