How to display Employee Number instead of Employee Name for reference variable field?

[prasannakumard]

Hi Team,

I've a reference type field on my record producer. It is referencing to User table.

The field name is: Employee number (Referencing to User table).

I used the following attributes for displying employee number and name. It is working as expected.

ref_ac_columns_search=true,ref_ac_columns=name;employee_number,ref_auto_completer=AJAXTableCompleter,ref_ac_columns_display_value=true

If I enter number in that reference field, it is showing employee name and number in search results and finally, setting the employee name.

------->

But, I need Employee number instead of employee name. I've update display value true for employee number on user disctionary table. But, it is reflecting for all tables.

So, can you please provide the feasable solution for the same.

Thaks & Regards,

Prasanna Kumar

[Michael Ritchie]

Unfortunately it is not possible to override the display value of a table for a specific reference field.   You can change it for the table only and any reference field using that table will also be changed.

[Allen Andreas]

Per what I see here, that doesn't seem true, what you've said:

Reference a table to show name instead of Number?

So sort of like this issue, but in the reverse way.

[prasannakumard]

Thank you Allen, By using the above mentioned post, I tried to give display value to Employee number and Name. But, it is taking one as display value as default. If I check the display value for both the field one field changes to display value as false.

Please help here.