Many-to-Many

Many-to-Many Relationships occur when each record in a collection relate to several other records in another collection, and vice versa.

Having too many relationship properties (especially many-to-many) on a single collection definitely degrades performance in Adalo, especially at scale.

Learn About Many-to-Many Relationships

---

Many-to-Many Relationship

A many-to-many relationship exists when records in one collection can be connected to multiple records in another collection, and vice versa.

Example: Tasks and Users

• One task can be assigned to multiple users AND One user can be assigned to multiple tasks

• M-M Relationships can not be added on creation of new record in database.

• M-M Relationships can not be set upon Create Action for new record.

---

Relationships vs Join Collections

Relationships are essential for organizing data in Adalo, but they come with performance trade-offs. Understanding the difference between direct relationships and junction collections allows you to make informed decisions about your data structure.

• Use relationships for simple, one-to-many connections and small datasets

• Use junction collections when possible for many-to-many relationships and before number of relationships to any single collection becomes an issue

• Plan ahead: Choose your data structure with growth in mind