How can choose a column in reference field?

[utente]

Hi,

I have a problem with the definition of one column form reference filed.

I can't understand where I need to specify the column of the second table (that contain the data that i need).

Whit this configuration (see the screenshot) i see only the field "sys_id"

Can you help me ?

[Pradeep Sharma · Accepted solution]

Hi,

You need to set display value of referenced table. You can only set one filed column as display value. Please refer section 3.1 for more info.

http://wiki.servicenow.com/?title=Reference_Fields#Selecting_the_Display_Value

However you can pull other columns in a drop down. Please refer below link for additional info.

http://wiki.servicenow.com/index.php?title=Auto-Complete_for_Reference_Fields

[utente]

Thanks you

[Pradeep Sharma]

You are very welcome Vincenzo. Thanks for participating in the community!

[Chad Wilhelm1]

Does this not apply to OOTB tables as well?  For example core_company referenced from sys_user does not have any display set but yet shows the name column.   I cannot find this in the docs so I assuming by default if you do not set one automatically sets name.  True or False?

Thanks,

Chad