Help

With linked fields, how to know which table originally established that link?

Topic Labels: Base design Data
Solved
Jump to Solution
527 2
cancel
Showing results for 
Search instead for 
Did you mean: 
luqmaan
4 - Data Explorer
4 - Data Explorer

In actual databases, I can explicitly define which table holds the linked column, e.g., Table A has a foreign key field to Table B. So, if I look directly at Table B by itself, I wouldn't know that it has a relationship with Table A. But that's okay, because Table B isn't supposed to hold that information itself.

But in Airtable, I noticed that when I put a linked field in Table A to Table B, instantly that field also appears in Table B. While that's very useful and helpful to understand the bigger picture of how things are interconnected, now I no longer know which table was the original one that established that relationship.

The purpose that I need to know this is to transform an Airtable base into an SQL database schema, so I need to know the "native" fields of each table. Any tips, or anything I missed?

1 Solution

Accepted Solutions

I have figured out a simple solution: by creating a dedicated grid view for each table that only shows the "native" fields, to be conventionally named as "Native". Thank you for your reply, it might have sparked this idea in my mind.

See Solution in Thread

2 Replies 2

I don't think that's possible I'm afraid.  Perhaps when you create the linked fields you could edit their names to include this information?

I have figured out a simple solution: by creating a dedicated grid view for each table that only shows the "native" fields, to be conventionally named as "Native". Thank you for your reply, it might have sparked this idea in my mind.