Many-to-Many relationships nightmare
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?