How Do You Define A Many-To-Many Relationship In Microsoft Access?
In a “many to many” relationship, one record in either table can relate to many records in the other table. For example, in a library database, one record in your Titles table could relate to several records in your Borrower table, since several people might have signed out copies of the same book. Conversely, each record in your Borrower table could could be related to several book titles, since each borrower might have signed out several books. These instructions are for Access 97. Create the two tables that will be used in the many-to-many relationship. Create another table, called a junction table. In the junction table, add fields with the same definitions as the Primary Key fields from each of the other two tables. Still in the junction table, edit the primary key to include the primary key fields from the other two tables. Create a one-to-many relationship between each of the two primary tables and the junction table. (See the related eHows for instructions.) Add data to the tab
