Here is a great example of using fmSearchResults to not only search across multiple tables at once, but to privilege certain results: in this case, treating documents tagged with a keyword as better matches than docs just containing the keyword text.
Video comes from the new document and asset management solution from 360Works: DocuBin. We’ll import a folder full of PDFs and then search the text within those PDFs from within FileMaker.
Check it out ( < 2 min ):
[youtube=http://www.youtube.com/watch?v=8AHGVDrXX-c]