Many-to-Many Relations

This type of relationship presupposes multiple connections of records in first table with records in the second table.

For example, you manage a Design Service Agency and calculate monthly payments to each designer according to the hours they worked. In this case the Many to Many relation between the “Hours Worked” table and the “Monthly Payments” table can be helpful.

In the most of cases the Many to Many relation comprises the Match Conditions. For example, there is the “Designer” column in the “Hours Worked” table and the “Monthly Payments” table. This column comprises Designer Id value. As a result the Designer=Designer match condition can be added to the relation. After that the “Total Hours” summary column can be added to the “Monthly Payments” table, where the total number of designers’ worked hours is calculated.

Next: Creating Relations