ContributionsMost RecentMost LikesSolutionsRe: Sync two tables to a third tableI used three, maybe there is a more efficient way to do it. Automation 1: When a record is added in the source table, I created a unique "Sync Key" in that table and added the record to the target table along with the Sync Key. Automation 2: When a record is modified in the source table, I modified the record with the matching Sync Key in the target table. Automation 3: When a record is deleted in the source table,I deleted the record with the matching Sync Key in the target table. ------------------------------ Gopi Mandela ------------------------------ Re: Sync two tables to a third tableI was able to do this using Automations. ------------------------------ Gopi Mandela ------------------------------ Sync two tables to a third tableI have two tables with the exact same fields. How do I sync these two tables to a third table with the same fields automatically? If a record is added, modified or deleted in the first two tables, the changes should reflect in the third table. Thank you. ------------------------------ Gopi Mandela ------------------------------