many-to-many relationship

A relationship between tables where records in each table have multiple matching records in the related table. This type of relationship may require changes in your database design. See also junction table.