Value List Sorted from Calculated field???

[Jana]

I've created a value list from a calculated field using the following formula which produces the string showing the JobNumAssignConc at the front. How can I make it sort alphabetically, like other value lists do?

Case ( StatusDue != "99 Closed" ; JobNumAssignConc & " " & ClientName & " " & JobTitle)

Help please from anyone in the know!

[Søren Dyhr]

I think I've guessed what you requirement is. As it is now is the sortorder dictated by the string starting with JobNumAssignConc ...and then later ClientName if too many JobNumAssignConc are equal. But you wish to keep a ClientName based sortorder??

You need to split the Case-calc' in two, and then define the valuelist on:

Case ( StatusDue != "99 Closed" ; JobNumAssignConc)

...and then use the option "Also display values from second field" and here should you use the second half of the split:

Case ( StatusDue != "99 Closed" ; ClientName & " " & JobTitle)

Now here come the crutial thing - There is two radio buttons below ...guess which one to use???

--sd

[transpower]

Enclose the formula in an Evaluate function and index that.

[Søren Dyhr]

Enclose the formula in an Evaluate function and index that.

This is new to me, would a popup build at all sans sorting order if no indexing is posible - I thought the list wouldn't be generated in the first place?: It's obvious to me that if you put inside a Evaluate( the indexing could work ...but the thread initiator stated that the list was there all right, but unsorted....

--sd