Help with Irreflective Symmetric Data

If I were to represent friendship in Airtable, it might look like this:

People
Name (single line text)
Friend(s) (linked record, linked to other People records, allow multiple)

But not sure if this is an ideal solution. Despite Sarah and Bob both being assigned to Fred as their friend, Fred only has Sarah as a friend. That might represent reality pretty well, but it means you need to manually assign friendships from both perspectives. Interestingly, that’s not how linked records work when linking records in separate tables.

This should be ok because I’m only using a small very controlled datasets to keep track of fictional relationships (I’m a novelist). Thank you.

Sounds like a very interesting way to use Airtable! Good luck on your novel.

Thanks. You see, my data is to keep consistent between novels and short stories because my world is much like comic books in that it’s all interconnected and consistent with each other. Like the Marvel comics or MCU. This is why I’m building a database to keep track of everything so as I continue to develop stories the threads are catalogued and consistent.