Jan 17, 202402:29 AM - edited Jan 17, 202404:52 AM
We have acquired another company that also uses Airtable. Both we and the new company have our own client lists in Airtable and we would like to combine these, as we have some shared clients already, without (at this stage) merging the Airtable bases in their entirety.
We would like people from both sides of the business to see each other's clients in one place, so that: 1. we can see which clients are shared 2. we don't create records for clients that already exist in one of the bases
New clients added in one base should be updated in the other base too.
Ideally, clients should be able to be created in the existing 2 bases and update across, rather than created in a new 3rd base, but if that's not possible then that's fine.
The clients will be linked to other tables in the respective bases and these linked fields should be displayed (via plain text if needed) in all bases.
Does anyone have any ideas how we can do this? We've come across some limitations with syncing (or we don't know how to use it properly).