AnsweredAssumed Answered

How to Add an Artist to a Gallery and Gallery to an Artist without duplicating

Question asked by FeldyNYC on May 11, 2014
Latest reply on May 11, 2014 by philmodjunk

Title

How to Add an Artist to a Gallery and Gallery to an Artist without duplicating

Post

     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.

     Thanks,

     Feldy

Outcomes