Many-to-Many relationships with metadata

[Maarten]

Hi everyone,

I'm hoping to create a many-to-many relationship between an entity and itself, with metadata added.

Example:

I have an entity: Organization.
An Organization can support another organization, or receive support from another organization.

When I create a many-to-many relationship on the entity Organization, with the same entity Organization, and call the left label: 'Provides support to' and the right label: 'Receives support from', then this works perfectly.

But now I would like to add two dates to this relationship: 1. when the support relationship started, and when it ended.
This is not possible in the many-to-many relationship.

In each organization I would like to have a two bottom panel showing:

Supports:
Organization name - from date - to date

Receives support from:
Organization name - from date - to date

Any ideas how to achieve this?

[yuri]

Hi Maarten,

I'd consider creating a separate entity with two many-to-one relationships.

While there's the ability to have relationship middle table fields, there's no support for date/time fields in the front-end. Hence, would require coding.

[rabii]

any chance in the future to have such ability (allow middle table to have more fields)? seems complex but would really enhance the user experience.

[telecastg]

If you don't want to code, I believe that eymen-elkum extension will allow you to do that

[rabii]

This extension would help you do the trick https://www.eblasoft.com.tr/espocrm-...le-inline-form