The relationship between CDs and songs is many to many because on the CD we have many songs and one song can be on many CDs. In this case we have to put the table between them to join a certain song with the certain CD.
The table in the middle will have a primary key on two fields which are the CDs primary key and Songs primary key.
Free Database Tutorials From VTC:
Access 2010
Access 2007
Access 2003
Access 2002
Access 2000
Access 97
Database Optimization
Data Modeling
Visual Basic for Access
For more free database, programming or software tutorials click here and do a search or click one of the categories.
