Searching + valuelists

[generatedname]

Couldn't find anywhere that this is brought up so far:

I use valuelists to populate drop down menus, the list can look something like

AAA = A string for the value
BBB = This is how it looks to user
CCC = Etc



Is there a way to make the search feature check the string representation as well?

Right now, if I search for BBB, all the records that were put in for BBB will come up....I was wondering if its possible for them to come up if I search for "how it looks" instead.

Thanks!

-Kurtis

[shannah]

Hi Kurtis,

Right now there isn't really a way to do this. The search in the top right is a text search - so it only searches varchar and text fields in the table - and only searches the actual data stored in the table - not the valuelist value - unfortunately. The Find form offers an easier way to search on fields like this.

-steve