Lookup table: show different fields in modal lookup and in the field control

[Andros]

Hi. I have an "orders" table with a CustomerID field which points to a "customers" lookup table.
I want that when I open the lookup table modal it shows a "Fullname" field in the list to pickup from, but in the CustomerID field (list/edit/view) I want to show the "ShortName" field instead.
How to do it?

[MichaelG]

You can use the Row_Rendered server event to format the view value for display. For example:

Field.ViewValue = "...";