Hi. For a music client I’m trying to set up a relational database that shows what’s essentially a genealogy of their genre, connecting the hundreds of artists they lay claim to based on influences and collaborations. Right now they’re all in the same table.
- Artist A influences Artist Z.
- An admin goes into Artist Z and associates Artist A as an influence.
- The record for Artist A automatically updates to reflect they have influenced Artist Z.
Sounds simple, but short of a convoluted flow of multiple duplicate tables I can’t figure out how to go about this. The other option is just an extreme amount of manual entry, which defeats the whole purpose…