Change default reference qualifier field set value

[ARAVINDA11]

@Ankur Bawiskar  @Community Alums  @Sohail Khilji 

Please help me with the query 

see the screenshot

We have a reference field in purchase order table with the name called VENDOR

The field name VENDOR refers to COMPANY Table

generally we if select any value to the field it will take name field and display the value in reference field

So If I want to modify it has it should set the value of another field value in company table instead of Name how can I achieve this 

also it is possible if we push another field value & set the name value in vendor field 

[Ankur Bawiskar · Accepted solution]

@ARAVINDA11 

whichever field is marked as Display=true on Company table that will be shown on the form once you select the value

Please discuss this with your customer as it will be global impact.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Mark Manders]

This can only be achieved by making another field the display value of that table, but that will be for everywhere where the company table is referenced.

[swathisarang98]

Hi @ARAVINDA11 ,

Yes you can achieve this by making display true for the field which you want to show but it will be global change,

also it is possible if we push another field value & set the name value in vendor field  - [ Yes its possible, in the attribute add ref_ac_columns and add your field name in the reference field then it will search with that field value and set the name  ] -swathi

I tried for searching with employee id in caller field,its working in pdi

Search using multiple columns in a reference field  

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang