AnsweredAssumed Answered

Found set from multiple tables

Question asked by MarkCampbell on Dec 26, 2014
Latest reply on Jan 2, 2015 by MarkCampbell

Title

Found set from multiple tables

Post

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?

Outcomes