Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Linking Three Tables Data to One Table's Field

Solved
Jump to Solution
317 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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!