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)

Hi,

Where is this numeric value list coming from ?

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

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

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.

...