Found set from multiple tables
I am trying to do a search on a keyword in multiple tables and then display the number of records found.
As an example, we have tables for each of Names, Cities and Occupations. The user enters "Baker" into a text field and presses a search button. How could I make a script to search each table for the string "Baker" in any field and then display the number of each found set in associated layout fields - e.g., "7 Names", "2 Cities", "5 Occupations".
Any suggestions? Can it be done?