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

[booher04]

Here's what I have.  Maybe there's something you'll see that is missing.  Maybe there is something else somewhere messing it up as well.  

[Abhinay Erra · Accepted solution]

I have overlooked your screenshot before, I see you have added it to the collection element of the table. You will have to put the attributes in the actual variable. Take out the attributes from the collection element of the location table.

[booher04]

That worked.  Thank you.  I thought I was doing something wrong and couldn't figure out why it wasn't working.  I put it into the variable attributes field under the variable and it worked.  Thanks!

[Abhinay Erra]

Glad you got it working!

[sai krishna10]

Open the cmn_location table and open the name field and make the display field as false and open the siteid field,make the display as true

Mark as helpful or correct based on impact