How to get field value instead of sys_id for reference type field????????????

[venkyyy]

Hi Team,

I have created a table "Expenses type" and added the data in it like travel. medical etc..,

Now, i need the data from this table to other field which i am using in other place, i am using in order guide.

I have taken a field and added reference field type to it and linked to above table to fetch the data.

But, i am unable to see the values like travel,medical etc.., but i am seeing their "sys_id" values.

How to resolve this issue?....i need to get the field values not sys_id's.

[Haritha Kotturi]

Reference field will display the field, which has the display value as true.

You've to go to table and check which field display value has true. And then

according to your requirement change the display value.