Sort lookup field by second column
Is there any way to sort a lookup drop down menu based on a second (hidden) column.
My lookup table is [Item | Order] I want item displayed and order hidden but used for sorting. Asc 1 - xx
But I see I can only sort alphabetically. Any ideas would be great.
Thanks