AnsweredAssumed Answered

A summary table

Question asked by user28271 on Feb 27, 2018
Latest reply on Feb 27, 2018 by Malcolm

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.