How to set a reference field to display results from a different field than "name"

[booher04]

I'd like to know the best way to set a specific reference field to show a certain field instead of the "name" field when selecting choices.  I have a field called "Office Location" and it uses the cmn_location table as the reference table.  It now shows "name" field results when you click the search, I'd like for it to show our "SiteID" field instead.  See screenshots below:

So Instead of what it's showing ("name") I'd like it to show the Site ID field. I don't want this to effect all of the cmn_location table for any time it's referenced, but for this particular catalog item(and any that are "office_location" in th Telecom category).

[Abhinay Erra]

I have tried it on my personal instance, it worked for me. I have set the search based on country and in the type ahead it now only shows the countries and search based on the country. 

[booher04]

Are you using the Service Portal and catalog items from there or from the "backend"?  

[Abhinay Erra]

I have tried it from the regular UI. Let me try it in portal

[booher04]

Yeah mine wasn't working on the Service Portal.  In the regular UI it opens the table window and we can see the columns there, but we need it to be able to be shown on the Portal UI. 

[Abhinay Erra]

It did work in the portal as well. But looks like for variable attributes ref_ac_display_value=false is not available. Rest of them worked, it did show the second field in the auto complete and I was able to search based on the field value mentioned in the ref_ac_columns attribute.