I have a table containing records of contacts, with columns for company, job title etc.
I’d like to create a second table in the same base that displays a subset of these records and syncs with the original table. For example, the second table might contain only records of contacts who work at a company called NewCo. And if I add a new record to the original table for an individual who works at NewCo, I’d like that record to automatically appear in the second table
I know I can use Groups to split up my original table by company, but that gets unwieldy quickly. Any thoughts on how I should proceed?