I have a typical CRM Airtable base that has three tables: Name, Company and Project. Records in the tables are all linked together.
Now I want to create another base that uses (syncs) information from two of the tables: Name and Company. It's easy enough to create a new Base and sync the two tables...but when I do, the linking between the two tables goes away. In other words, in the new Base I lose the knowledge that John Doe works for XYZ company. It shows us as text, of course, the records are not linked.
Is there any way to fix this?