In Microsoft Access, a Relationship helps you to merge or link data from one table to another. Relationships allow the user to create Queries, Forms, and Reports.

Putting the relationships to work Accommodating the many-to-many relationship is a simple four-step process: Delete the existing relationship between the two tables. Create the associate table and ...