Many-to-many (N:N) relationship
A Dataverse relationship pattern where records on both sides can relate to many on the other — implementable as native N:N or via a custom intersection entity.
A many-to-many (N:N) relationship in Dataverse models situations where records on both sides can relate to many records on the other — Students enrolled in Courses, Products tagged with Categories, Contacts on Marketing Lists. Two implementation patterns: native N:N (a system intersect table created automatically; simple binary "associated or not" relationships with no extra fields) and manual intersection entity (a custom table representing the relationship with its own fields, lifecycle, security, business logic). Native N:N is quick and easy but limited; manual intersection is more work but supports rich relationship data — role, dates, status, custom attributes. Choose based on whether the relationship needs its own attributes and lifecycle.