How to add a related field in reference lookup list?

[Med99]

Hello, I have a reference field in one of my forms called Category Level 2 that points to a custom table x_company_category. That table has a self-reference field called parent.

When I click the lookup icon, I want the popup list to show the current record's name, his parent and the grandparent (parent.parent).

Is it possible to display those columns in the reference lookup popup? If so how? Thank you

[Ankur Bawiskar · Accepted solution]

@Med99 

you can configure the list layout when you click the Magnifying glass and then add the required fields.

But remember this will impact every place where this table is being referred and it will show always those fields in list

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Med99]

I added it but I notice that they have the same column name , is there a way to modify just these colum names to avoid confusion. Thank you

[Ankur Bawiskar]

@Med99 

Nope, you cannot change the column label.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Med99 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.