How to organize inter-linking data?


Hi all,

Wondering how Airtable can help me organize the following data in the most useful way:

I have 1) in Tab 1 a list of every post on my blog with the primary field being published URL and 2) Tab 2 a list of every post internally linked to another post + the anchor text each link is embedded in, with the primary field being undefined at the moment.

I’d like to be able to view in a glance, in the card view of Tab 1, a list of all the posts internally linked to and the anchor text each inter-link is embedded in.

Does this make sense? I have a feeling Airtable can help, but I don’t have a lot of experience with databases so I thought I’d ask for help. Let me know if you have any questions!