Reference field not displaying 'display' value

[sigmachiuta]

So I have a reference field on a catalog item and when i type ahead lets say 'foo' nothing shows up even tho foo is in the related list.   But when I select the eyeglass to search it does bring back foo in the results. I have the display value on the field I am neeeding returned in the search criteria type ahead and I have done this on other reference fields with out a problem.   I am not sure why this one is acting different or what i might have changes to mess this up.   Any ideas would be appreciated.

[sigmachiuta]

yup I set the below attributes:

ref_ac_columns_search=true,

ref_auto_completer=AJAXTableCompleter,

ref_ac_columns=u_foo,

ref_ac_order_by=u_foo

Yup the display value is on the correct field in the table

[sigmachiuta]

I changed the display field to another field and all the attributes....   Worked fine...   weird.   So I am not sure why this one reference field is 'confused'

[sigmachiuta]

After a lot of testing I think there is something screwed up with the referencing table.   I created a new table and added a reference to the application table.   Then I tested in the form it showed the correct display value.   I added a new variable in the service catalog and referenced the variable to the new table (I added a few records in the new table for testing ) when I set a variable in the catalog to reference my new table autocomplete is confused but when i click search the correct application shows up , this might be a HI ticket.