Yes, this is one of the more disappointing problems with Airtable.
When records sync from Base A to Base B, those records get a brand new Record ID in Base B. This is why all the linking breaks.
So if your original records from Original Table 1 previously linked to Original Table 2 in Base A, and then you sync both Original Table 1 & Original Table 2 to Base B, the linking between Sync Table 1 & Sync Table 2 will no longer work in Base B.
The quickest & easiest way to solve this problem would be to make sure that all of your records in Original Table 2 (in Original Base A) have **COMPLETELY UNIQUE** values for their primary field. This will not work if there are any duplicate values in your primary field of Original Table 2 (in Original Base A).
If all the values are completely unique in Original Table 2 of Original Base A, then you can proceed further:
In Base B, go to Sync Table 1, and you will notice that your linked record field in Sync Table 1 has been converted by Airtable into a single line text field. You should be able to convert that single line text field (in Sync Table 1 of Base B) back into a linked record field again that links to Sync Table 2 of Base B, and Airtable should automatically re-link the records for you.
p.s. I will need to make a YouTube video of this at some point in the future, so keep an eye on my YouTube channel. I am also available for hire as an expert Airtable consultant to help with issues like this.
