Creating links between tables
PreviousCreating lookups and rollups between tablesNextStacker Tables: Editing field names and types
Last updated
Last updated
Links between tables enable you to share data across tables and data sources.
Click Manage fields and data
Go to the table you want to set the link, and click Fields.
Click Add field and select Automatic Link.
Enter a field name (we suggest choosing a name that accurately reflects the information the data is linking, e.g. 'Link to Client')
Select a table you want to create the link to.
Select which fields you want to link. Please note: in order for the linking to work, the values in the fields selected must be identical.
Select the relationship type.
Once saved, you will see the new field in the field list. The link is also visible in the table you've linked to — though it is not editable from this side.
In our Property app, we have created a link between our Sales table and our Team table. We want to assign each team member to sales.
We can now select names from the Team table to link to our Sales table.
You can use this to link between different Airtable bases or even different data sources. In order for the linking to work, the values in the fields selected must match exactly. Links must be created in an Airtable table to connect with other data sources.
To delete the field, scroll to the linked field and use the trash icon to delete.