AnsweredAssumed Answered

Many-to-Many relationships nightmare

Question asked by erenerm on Aug 18, 2009
Latest reply on Aug 19, 2009 by comment_1

Title

Many-to-Many relationships nightmare

Post

Here is the information I have: 

 

Many records of different art works. Artwork 1 needs bibliography that includes several different books BookA BookB BookC and page numbers for each of those references. The problem is that Book A also connects with Artwork 2 and Artwork 3 while Book C has its own set of unique artworks that it references etc etc.

 

 

 

I am in the middlle of creating my first database as part of a project. I know that this is a many to many relationship, but I do not know how to program it into my database. Help?

Outcomes