Hey Notion / relational database gurus, I could use some help. I've got 3 databases:
- Musicians
- Instruments
- Songs
I need to assign specific musicians to specific instruments on specific songs. "Song 1" would have "Musician 1" on "Drums"; "Song 2" would have "Musician 2" on "Drums", and so on.
Follow
@brad_frost I don't know Notion, but the standard pattern for a relational database would be to add a new table to describe this relationship, with just those three keys, that could then be referenced in relation to any of the three main tables.
