Note: FileMaker 12, released a few months after this article was written, introduced a “Find Matching Records” step, effectively eliminating the need for the techniques explored below (except for the section on case-sensitive searching).
Have you ever right-clicked into a field (or Ctrl-clicked if on a Mac) and chosen Find Matching Records? It works remarkably well, but oddly enough, there is no scripted equivalent for this command.
Of course if we do a Find Matching Records and then invoke Modify Last Find…
…we can see what FileMaker is doing behind the scenes. Continue reading “Locating Matching Records, part 2”