No announcement yet.

Many-to-Many relationships with metadata

  • Filter
  • Time
  • Show
Clear All
new posts

  • Many-to-Many relationships with metadata

    Hi everyone,

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


    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:

    Organization name - from date - to date

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

    Any ideas how to achieve this?

  • #2
    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
      rabii commented
      Editing a comment
      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.

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


    • #4
      This extension would help you do the trick