Different lookup display field for List page

eppa · Post by **eppa** » Wed Feb 18, 2015 6:27 am

Hi,

I am wondering if there is a way to select a different "Display Field" in the List page when using a table lookup. For example, in the lookup table we have a field Fullname which we want displayed in all other pages but in the List page we want to display the field Abbreviation. Hope this makes sense.

Thanks,
Greg

vincenthung · Post by **vincenthung** » Wed Feb 18, 2015 12:50 pm

You may consider to setup the view value in the "Row_Rendered" Server Event.

Setup both the "Fullname" and "Abbreviation" as the display field.
Determine the view value by different page id.

Example:
Dim arDisplay
arDisplay = Split(<Table>.<Field>.ViewValue, ",") ' The view value of multiple display field is comma seperated
If CurrentPageID = "list" Then
<Table>.<Field>.ViewValue = arDisplay(0)
Else
<Table>.<Field>.ViewValue = arDisplay(1)
End If

eppa · Post by **eppa** » Thu Feb 19, 2015 10:53 am

Thanks, great option for list page - worked well.

Now trying to work out how to separate in the Add/Edit pages where the combined values are in a drop-down select box.

Cheers.