Displaying a Non-Display Field in Reference Field

[markmmiller09]

I am wondering if it is possible to do the following:

A,B, and C represent columns in table 1 where A is the Display field.

A

B

C

X,Y, and Z represent columns in table 2 where X is the Display field.

X

Y

Z

In a form view for table 2, is it possible to have a reference field which references a column other than the Display field, say C, from table 1. So a user can type the data related to table 1, column C and store that in the reference field on the form for table 2?

Changing the Display field for table 1 would effect other forms, therefore, I cannot take that approach.

Any ideas?

[harikrish_v]

I dont think so mark, according to wiki:-

3.1 Selecting the Display Value

Only one field can be defined as the display value for a table.

So you wont be able to achieve this.

[markmmiller09]

Hey Harikrishnan,

thanks for the quick response. I wonder why they don't offer this kind of functionality...

[Pradeep Sharma]

Hello Mark,

You have to set the "ref_ac_columns" attribute in the dictionary for that particular field.Please check the below link for more Auto-Complete for Reference Fields - ServiceNow Wiki

Kindly let me know if you have any questions

[harikrish_v]

Pradeep Sharmahey Pradeep, even then, once you select the value, the "display" field will be shown as the reference field's value rt?

Regards,

Hari