Another relational valuelist problem!

[Adam McCabe]

For reasons best not explained here, I want a valuelist that pulls from a table that contains two fields (Name and Order) that will sort the list by order but only display name.

I've created an Order = Order self join and set up a valuelist based on two fields to accomplish this, but I can't find a way to hide the order (second) field when selecting from the valuelist, even though the list only gets populated with name (first) field data.

Is there a way to have a list that is sorted by a field that doesn't appear in the list?

[corn]

Is there a way to have a list that is sorted by a field that doesn't appear in the list?

Unfortunately, no. Display of values within a list and sorting of that list are bound together. Moreover, sorting on a column both requires that column to be indexed and collapses the value list to only the unique values of the sorted column.

[comment]

See if this helps.

[Adam McCabe]

Comment:

That worked quite well, thanks.