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]

You can dd attributes to show siteId. Add the field name of siteId in the ref_ac_columns, ref_ac_columns_search. Refer the following link

Reference field

[booher04]

I tried updating the attribute and it didn't change anything on the form in the portal.  I used the "u_site_id" value.  

ref_ac_columns=u_site_id, ref_ac_columns_search=u_site_id.  Am I missing something?  

[Abhinay Erra]

put this in the attributes. This will hide the display value and only show the u_site_id field

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_site_id,ref_ac_columns_search=true,ref_ac_display_value=false

[booher04]