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).

[goulart]

I would not recommend change display value of the tables.

In a choice list you can use atributes to do it.

ref_auto_completer=AJAXReferenceChoice

ref_ac_display_value=false

ref_ac_columns= list of columns separated by a semicolon

[booher04]

Does this only work on Choice list fields and not on Reference fields?

[goulart]

It should work on reference fields. 

Have you already tried ?

[booher04]

Yeah it's not working on the catalog item in the Service Portal.

[SanjivMeher]

Did you add the attribute to the variable or to a field in your target table?

It should be added to your variable in the catalog