How to change the reference field

[sgp]

Hi ,

I have create a custom table .I have using a reference field on a form to this   query table.From the reference field it is querying the sysid we want to change it query the name from the table is it possible.

Could please help

[bernyalvarado]

To choose a field as a display value for the table:

1. Navigate to System Definition > Dictionary.
2. Filter on Table is <name of the referenced table>.
3. Locate the desired field and set Display to true.

   For best results, choose a field that is required and unique in each record as the display value field.

[bernyalvarado]

I hope this helps

[bernyalvarado]

http://wiki.servicenow.com/index.php?title=Reference_Fields#gsc.tab=0  

Thanks,

Berny