Referenced table not displaying column label

AHMED OLAGUNJU
Tera Contributor

I referenced a custom table in my form; the table I referenced has few records. When I want to select from the referenced table, only the Sys_ID of the records in the referenced table is displayed. 
I want my display to show few columns from the referencing form, as we used to have if we referenced a sys_user table

.

AHMEDOLAGUNJU_0-1768468514109.png

 

2 ACCEPTED SOLUTIONS

Brian Lancaster
Kilo Patron

Go into your custom table and make sure you have a field with Display set to True. That will then display that field in the reference instead of the sys_id. Example screenshot below.

BrianLancaster_0-1768493300905.png

 

View solution in original post

Adrian Ubeda
Mega Sage

Hello @AHMED OLAGUNJU ,

 

Apart of changing display value in table definition, you can configure the list layout (Right click) and add/remove fields as needed 

If it was helpful, please give positive feedback! ✔
☆ Community Rising Star 22, 23 & 24 ☆

View solution in original post

6 REPLIES 6

yashkamde
Giga Guru

Hello @AHMED OLAGUNJU ,

The solutions from @Adrian Ubeda  and @Brian Lancaster  should helped if it doesn't fulfill your requirement try using :
"ref_ac_columns=number;{column_1};{column_2}"

in attribute field in configure dictionary..

If my response helped give as helpful as accept the solution..

In this way ...

Screenshot 2026-01-15 225107.png