I have a table with a mix of text fields, some of which use lookup tables and are storing the id number of the value.
In the list view, when we do a "Search for" "any field" "contains" we can only get returns from fields that don't store an id - not the ones that use lookups and store ids.
Is there any way to make the simple search crossref the id to the value in the lookup tables in its search?
I realize it might not be easy because when you don't specify a field to search there is no crossref to a particular lookup table to make - it would have to check all of the lookup table values.
My users pretty much expect "Search for" "any field" "contains" to work just like it says...it's hard to explain to them why it doesn't.
It would help even if you had to specify a field, and it would work with lookups.
Any thoughts? Workarounds? Is that a bug or feature request?
Thanks!!!
