valuelist sorted by 2nd field displayng only 1st

[Irenem]

Hello everyone,

I have a value list displaying names. I want to sort them by a second field (sort number).

Example:

1 Lisa

2 Ann

3 Ben

But I don't want to display the number but only the names. Is there a possibility to do so?

[Vaughan]

Yes. You'll need to have the values in a table, and set the value list to display the first field but sort by the second. There is another option to just display the second value. But that's not what you want.

The only other option I can think of is to use a portal interface: you have more control over the sorting of the portal, and it handles loger lists of options better anyway (though it is overkill for smaller lists).

[Irenem]

Thank you for answer so quickly.

But the problem is that I cannot sort by the first field and display only the second. When I set the option to display only the second value, the sort option automatically moves to "sort by second filed".