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.

Outcomes