Sort Value list

[Rainy Pass]

I am using a value list and a relationship to retrieve and de-dup some data. How can I custom sort the result?

The field in question outputs: LRG MED XXL

I need the output sorted MED LRG XLG

[Rainy Pass]

FYI

Solved the problem by adding a calc field to the child table to assign sort value to the value list. (MED = 1, LRG = 2...).

Selected Display second field in value list and sorted by the second filed (SortCalc).

The interface is not effected by the second field since the value list is only not used as a menu anywhere, only to populate a field.

The value list now has a custom sort.