How to Add an Artist to a Gallery and Gallery to an Artist without duplicating
I have a Gallery Table and an Artist Table.
I would like to add an Artist that is represented by the Gallery and then when I look at the Artist be able to see which Gallery the artist shows at.
Should I Create a new table called Artists_Gallery_Representation - with a unique ID? Should I create an artist Field and a Gallery field? or Foreign Key fields for Artist_FK or Gallery_FK?
Any guidance would be appreciated.