Help

Linking Three Tables Data to One Table's Field

Solved
Jump to Solution
672 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Bar_Maaravi
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi All!

So here is what I’d like to do.
I have a base with four tables. All look precisely the same in terms of fields (types and names).
For your understanding, the first three tables are lists with data about particular individuals. And the last table includes all individuals.

My goal is to create a field on the fourth table that will let me know by the person’s “Name” (which is the first field) in which table he/she is located.
But, some of the records repeat themselves in different tables, so I’d also like to know if the record is in “table1” and “table 2”.

Thanks In Advance,
-Bar.

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

That doesn’t sound like the best way to setup your base.

Instead of creating different tables, all of your people should be in one table, and then you can use different views to organize them differently.

You can learn more about views here:

And I also discuss views at length in my free Airtable training course here:

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

That doesn’t sound like the best way to setup your base.

Instead of creating different tables, all of your people should be in one table, and then you can use different views to organize them differently.

You can learn more about views here:

And I also discuss views at length in my free Airtable training course here:

Actually when thinking about it, after you mentioned organizing it by views it sounds just as the right way to do so.

Thanks a lot!