I’m likely overlooking something simple but I need to find a solution to the following problem.
I have a table of local bands and a table of local musicians. They are linked so that I can add each musician as either a member of the band or a songwriter in the band.
So far this works fine. But I need to populate other tables with names of the local musicians. For example, I’d like to have a table called “local songwriters”, that is populated automatically with names from the local musicians table when a musician is listed as a writer in the band table.
Either that or I need to be able to categorize local musicians into either a. songwriters, and/or b. bandmembers so I can then take their names, not from the local musicians tables, but from the table of songwriters or the table of bandmembers.
Furthermore, I need a list or table called “Session musicians” also to be populated with names from the Local musicians table.
I’m not sure how to structure this.