This may seem like a rather neophyte question, but I am running into a problem and I don't know if there is an adequate workaround.
I've got a database that has 10 different layouts. Each layout is based on a different table and there aren't any fields that overlap across the layouts.
How can I perform a find/search of the entire database and show the results? Would it be easiest to create a new layout for this purpose or a report, or is it even possible?
I don't want to build a new layout that has hundreds of fields from all of these tables.