Support many-to-many relations between objects

[chkw-rks]

Hey all!

I searched existing issues for "many to many", "many companies", and "many people" but didn't find any relevant discussion yet. Apologies if I missed an existing thread, happy to move this there if you point me to it.

Problem

Custom relations only support "Has many" and "Belongs to one." There's no native way to model many-to-many relationships, even though many real-world cases need them (a person working at multiple organizations, a contact linked to multiple clients, etc.).

Proposed solution

Add a "Many to many" option to the relation type dropdown. Twenty could auto-generate the join table behind the scenes so users don't have to model it manually.

Ideally, linked records would also be visible directly in table/list views (e.g. a Person row showing all their associated companies in one cell, and vice versa) so the many-to-many relationship is usable also in the overview, not just on the detail page.

Current workaround

Manually creating a custom join object (e.g. an "Affiliation" object with two "Belongs to one" relations, one to Person, one to Company). This works, but comes with some friction:

• The join object adds an extra entity to the data model, even when users don't need to store any metadata on the relationship itself.
• Each join record requires a title/name field, which adds mental overhead since these records often don't have a meaningful identity of their own (what do you call the link between a person and a company?).
• Viewing related records requires going through the join, e.g. opening a Company shows a list of Affiliation rows, and reaching the actual Person takes an extra click.
• Notes, tasks, and attachments can end up split between three places (Person, Company, and the join object), when users often just want them on Person or Company directly.
• The pattern needs to be explained to new users and team members before the structure becomes intuitive.

Curious about your opinions and if there are already some directions or other workarounds - thank you!

[MAKINWARA]

Hi there.

Would it be nice to add one-to-one(1:1) relationship too? I search the repo but could not find anything about this either.

Happy to discuss further.

[BOHEUS]

@chkw-rks there is a native way for many-to-many relations between objects, please check the documentation https://docs.twenty.com/user-guide/data-model/how-tos/create-many-to-many-relations

[chkw-rks]

Unfortunately, it seems I can not get it to work. I am not able to select the target of the junction, what am I doing wrong?