Lookup table field values in List Page

amneo · Post by **amneo** » Tue May 14, 2019 1:53 am

In the Add Page of the table transaction_details Field Name transaction_details.document_number
I am looking up values from

document_details.document_no and document_details.document_tittle

the return value to the form is only the document_details.document_no

For some reason the List page lists the column value as transaction_details.document_number , document_details.document_tittle

How can I restrict the list page to only show the column transaction_details.document_number ?

More explanation.

Add form of transaction_details Looks up

document_detaiil

document_no | document_tittle
01 | Document 01
02 | Document 02

and inserts value to

transaction_details

document_number | doc_location
01 | x:\drive

List page of transaction_details shows

transaction_details

document_number | doc_location
01 , Document 01 | x:\drive

How can I restrict the list page to only show

transaction_details

document_number | doc_location
01 | x:\drive

arbei · Post by **arbei** » Tue May 14, 2019 10:59 am

amneo wrote:
For some reason the List page lists the column value as transaction_details.document_number , document_details.document_tittle

A lookup field shows all Display Fields you selected in the Lookup Table panel, see the topic Lookup Table in help file.

If you want to show the field different than that in the selection list, you can use Row_Rendered server event to change the ViewValue of the field, see the topic Server Events and Client Scripts in the help file.