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

[kamalsoni]

You want to use value instead of sys_id.

By default value of reference field is sys_id

and display value of reference field is what we see in form or table.

You can use

current.fieldname.getDisplayvalue();

[Jaspal Singh]

Hi,

When you click on reference field you get list of sys_ids for that table. All you need is to right click the header column of the pop up list & then use configure list option. Once done add necessary columns from available to selected section of the custom table.

[bernyalvarado]

Hi SG Pillai,

You just need to change the display field of your table.

Thanks,

Berny

[sgp]

Hi bernyalvarado

Can please let me know how to change the display field of the table.