Help

Records linked to others from the same table

Topic Labels: Base design
158 2
cancel
Showing results for 
Search instead for 
Did you mean: 
martalopezAT
4 - Data Explorer
4 - Data Explorer

Hello community! 
I am looking for assistance with the design of a table that involves records with a field linked to other records within the same table. I know how to include differed records in a field but I donk know how to see in the second ones that have been connected. 

Let's see an example: 

I have a table with a list of schools. I mark in a field of one of the records (school 1) that collaborates with 2 other schools (school 2, school 3) (I use a field linked to the base that permits multiple records). The question is: how can I see inside the records school 2 and school 3, that they have been linked to the record school 1? Is it a way to get this? Thank you very much 

Marta

2 Replies 2

Hmm, I think you'll need a script for this I'm afraid

Dan_Montoya
Community Manager
Community Manager

You should be able to use a lookup field for this.  So if you wanted to see the addresses of school2 and school 3 you would add the lookup on the linked record field.