Oct 23, 2023 03:43 PM
I have a table in a base, but I want to move this table to a different base. However, I am using it as a linked table in other tables' fields. Is it possible to move this table to another base and keep the linked record information on the other tables? Or it will break the links?
Thanks in advance.
Solved! Go to Solution.
Oct 24, 2023 09:48 PM
Primary/Foreign keys relation exists 'under cover' and rely on record IDs.
If you want to preserve relations with high accuracy, you can add formula RECORD_ID() in your table and reflect it in foreign tables via lookup.
By way, if you paste a list of record IDs into link field, and these IDs exist in linked table, Airtable will turn it to real links.
Oct 23, 2023 05:42 PM
Hi,
You can copy instead of move. But if you need to delete a table from source base and save lookup info, edit lookup fields and turn them into static form (text, number, etc...)
Oct 24, 2023 08:40 AM
So if I really want to move this table out of the base, I will lose the foreign link to this table.
Oct 24, 2023 09:48 PM
Primary/Foreign keys relation exists 'under cover' and rely on record IDs.
If you want to preserve relations with high accuracy, you can add formula RECORD_ID() in your table and reflect it in foreign tables via lookup.
By way, if you paste a list of record IDs into link field, and these IDs exist in linked table, Airtable will turn it to real links.
Jul 11, 2024 05:23 AM - edited Jul 11, 2024 05:26 AM
another option is to sync a table to the new base. After the table is synced simply delete the sync and convert to un-synced table.