Reference field displaying sys_id Instead of name value

Taylor2
Kilo Contributor

I have created a reference field within a table but taking a look at the table list the reference field shows the sys_id instead of the label name?

 

find_real_file.png

The parent name is "Test".

I have made display value true on the field but it still shows the sys_id rather than name.

 

 

7 REPLIES 7

This was something I noticed I forgot to add to the form control a few days ago. Even with the updated form control, it doesn't display the value it shows the sys_id. 

Taylor2
Kilo Contributor

This was something I noticed I forgot to add to the form control a few days ago. Even with the updated form control, it doesn't display the value it shows the sys_id. 

Johnny17
Kilo Expert

Late post, but in case someone stumbles here, these are the proper steps:

1. Go to the curent table configuration (right click on context menu / COnfigure / table 
 
2. Find the field in question (that's referencing another table)
 
3. Go to its referenced table  (the referenced table can also be found & directly clicked under the column "Reference" inside the table config)
 
4. Find the field that bears the label (“Name”, “Title”, “Short Description” etc)  and set its Display to TRUE
 
5. (Don’t forget to) Press “Update”, on the (referenced) table config, otherwise it does NOT WORK. 
 
6. Refresh original list view and the sys_id should be gone and the record's name should display instead.


Please mark this answer as correct, if it helped you.