Solution | fmSearch Results 7

fmSearchResults was written by Matt Navarre after hundreds of hours of pondering search in FileMaker. After researching, testing, and refining, it was released. Each new version brought features, such as name substitution, data entry correction (for date fields) tooltips, QuickFind control, and more. 

It boils down to this: FileMaker does some things very very fast. If you can take advantage of these, and do them serially with changes each time, you can get amazing results. 

What is FileMaker really great at?

• Searching an indexed field in the local table
  • Especially with a relatively small found set
  • Finding no matching records (which can be a good thing… read on)
• Running complex script code quickly
• Running scripts on the server (local access to data)

What is FileMaker bad at?

• Intelligent single field search (think Google, or Bing. Or even Lycos)
• Search in a related table of any kind (and your database is normalized, so this is important)
• Searching unindexed fields
• Displaying a list of results from more than one table (we aren’t talking about a portal here)
• Displaying a list of records with a large found set
• The Quickfind feature (It’s affected by all of the limitations above)
• Knowing what you are looking for before you do a search

How SearchResults works:

1. User enters a search string (into a global field)
2. Determines what type of data the user entered (person’s name, date, phone, currenty, range of data, text, etc)
3. Looks only in the tables and fields where that type of data exists
4. If no results are found, it loosens the criteria and searches again, and repeats until either records are found, or they aren’t likely to exist.
5. Continues through all the desired tables in your database
6. Displays the combined results on one page

In a database with millions of records and dozens of tables, it can do all of that in a fraction of a second.