Question

I'm using Notion for personal use to keep track of magic tricks I've performed for friends and family. I have three different databases that I want to be able to share information between.

Repertoire Database - This contains the name of the trick and some other information about each trick I want to keep track of.

Friends Database - This contains a list of my friends and family that I've performed magic for.

Performance History Database - This contains the name of the person I performed for. I've successfully created a Relation so that I can link the trick's name in one column to my Repertoire Database and my friend/family name as a Relation linked to my Friends Database.

What I'd like to also do is create some sort of Relation in my Friends Database that will look at my Performance History Database and show me all the tricks that I've performed for that particular friend. Is this possible and if so, can anyone offer a suggestion?

Thanks,

Dave

Answer 1

You can do this with only two Notion databases.

1- Repertoire Database.
2- Friends Database.

Relate the two databases and then in the repertoire select your friends or the other way around.

This will show you exactly that in both databases, in front of the tricks database names a column with your friends and in front of your friends database names a column with the tricks performed, so you can see the information in both.

If you don't need any extra information, that will work.