I do not have an answer for the misspelling issue, but I have two suggestions. The filter box does supports the use of the words AND as well as OR (in upper case). Very few users know this.
But even if you ran a training class for the techs, over time there will be new techs hired and that knowledge will fade away. It is also confusing how to use the OR as well as the AND in that filter box at the same time.
Another approach would be to make a form to fill out which will have fields to enter for the search criteria clearly labeled as to if they will be treated as an AND or and OR filter.
Say 5 fields for "Must contain ALL of these""
say 5 fields for "Must contain ANY of these" or leave blank.
If you have a table of users where the Key field is the Userid, the users search terms entered on that form can be lookup down to the data base and a formula field can evaluate if the record qualifies. The reference field in the database table will be [Current User] with a formula of User().
The report Link of qualifying records can be shown as an embedded report on the user's search terms record, upon saving their record and getting back to View mode.
I bet that relatively simply enhancement would help a lot and be fully practical quickly.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
