Sorting lookup fields

Sorting lookup fields

I would like to present the options in a Lookup field in a particular order. I know I can set the field to be sorted alphabetically but none of the fields in the table relate to the sorting order. Ideally, I would like to add a field to the table in which I can set the sort order for lookup fields to that table. But I don't want to display this 'sorting' field.

Anyone: Do you know how to achieve this with what we have now?

ZC Support: If not possible now then please add this feature.