Page 1 of 1

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

Posted: Sat May 27, 2023 12:20 am
by 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?


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

Posted: Sat May 27, 2023 7:27 am
by MichaelG

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

Field.ViewValue = "...";