Help

Linking a table to another table in the same base

Topic Labels: Base design
Solved
Jump to Solution
2003 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Scawen
4 - Data Explorer
4 - Data Explorer

Hi I’m newish to Airtable and I haven’t got to grips properly with Linking. As a newbie I’m using the ‘free’ version of Airtable. Do I need to have a paid account to link tables? If not please help, thank you very much in advance.
Mike Scawen

1 Solution

Accepted Solutions
Vivid-Squid
11 - Venus
11 - Venus

HI @Michael_Scawen ,
You have access to everything you need in the free version.

Lets say you have 2 tables. the first one called People, with a field called names. Another table called pets with a field called Pet Name.

In the People table, add a new field that is type Link to a Record. Choose the Pets table. Now click into the new linked Pets record for the first person in the list and choose a Pet.

Now both tables are linked to each other. You can no add Lookup type column if you want to pull in more data about the pet other than name.

See Solution in Thread

3 Replies 3
Vivid-Squid
11 - Venus
11 - Venus

HI @Michael_Scawen ,
You have access to everything you need in the free version.

Lets say you have 2 tables. the first one called People, with a field called names. Another table called pets with a field called Pet Name.

In the People table, add a new field that is type Link to a Record. Choose the Pets table. Now click into the new linked Pets record for the first person in the list and choose a Pet.

Now both tables are linked to each other. You can no add Lookup type column if you want to pull in more data about the pet other than name.

Many Thanks for your advice and time. It seems I was on the right track but your confirmation is helpful and confidence building.
mike

Good Luck! Let me know if you have any other questions.