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?