creating a single box search (like a google search)
I would like to create a single box search engine in FMP 10. So far I've come up with two methods for a very simple one box search but I find each one a bit lacking.
1. Create a script with a custom dialog and a global field for user input. Whatever is typed in the global field is then used to fill a multiple "or" search (enter find mode, set field, new record set field...) for all the major things a user would search for (client, date, project, etc). The problem with this approach is the user would have to know before hand which fields would be searched by the script. Also the more search catagories the slower the script.
2. create a script that searches a calc field which is populated by any fields a user would search (mytable::search calc = mytable::client & " " & mytable::project & " " & etc). Again the user would need to know which fields would be included but this would not require the "or" type search and thus would be faster (maybe).
My sticking points are....
1. Is there some other better way to do this?
2. I would like to add to my search's custom dialog an omit option and a constrain option (one global to enter searchs and the 3 buttons of the custom dialog be "search", "constrain" & "omit"). Perform search works dynamically. Is there a way to do constrain or omit dynamically?
Thanks for any help that may come....