Sorry if the question header is confusing.
In my system I have a contact table, and staff table, a vendor table, an address book table.
I wanted one searchable list of all of them.
This is how I did it.
New Table, linked to each of the "other" tables.
Script in each of the other table layouts to sync with this New Table whenever a record is created or modified.
Curious if anyone has a better idea to do this.