Sort Value List in Reverse Order

[Clem]

I need to sort a value list in reverse order of one of the displayed (numeric) fields, but there appears to be no native funtion in FM (v5) to do this.

Obviously, I could create a calculated field with a *-1 version of the original field and use that, but that field would then have to be displayed (a bit ugly). And as the list is to be used to insert a value into a field, I will then have to re-calc to get the correct value in.

Does anyone know of a more elegant solution?

Thanks

Clem (still [fairly] new to Filemaker - so be gentle with me)

[Ugo DI LUCA]

Hi,

Where is this numeric value list coming from ?

A field, a pre-defined value list or a relationship ?

[Clem]

It's coming from a field in the same table.

[Ugo DI LUCA]

Hi,

Not less ugly than your first solution, use the option "show also field", choose the calc you talked about, and use "sort by second value".

or

if it is just a matter of display on layout, use the calc as your value list, but turn the field to transparent (text and background).

you need

field A ----> value list of calc Field C = Field X *(-1)

field B-----> Field A * (-1)

So Field A is transparent and Field B is displayed behing Field A, but only the values of Field B would show, and next calculation would use Field B.

...