Many -to - Many

Walter
Walter Customer, Community Captain
10 Comments September Badge of the Month Community Captain Photogenic
edited September 24 in Platform

Hello,
Is there a way to get around a many-to-many type relationship in board?
I know bridge table concept……. However, it doesn't seem to help in my case.
Thanks in advance

Accepted Answer

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    Answer ✓

    Hello @Walter ,

    usually, you'd connect different entities that are in a many-to-many relationship by using a cube. This cube would have the entities that shall be set to relate as dimensions. The relation itself will then be built by populating the cube with a non-zero value (usually a "1") for each relation.

    When selecting one of those entities on the screen (or in a procedure) the other one will be selected by "Select based on Cube"—using the Relations-Cube as driver.

    Best,
    Helmut

Answers

  • Walter
    Walter Customer, Community Captain
    10 Comments September Badge of the Month Community Captain Photogenic

    @Helmut Heimann thanks for your reply to my question. I will try to apply this.

    Thanks

  • Walter
    Walter Customer, Community Captain
    10 Comments September Badge of the Month Community Captain Photogenic

    @Helmut Hermann

    Are there any resources that I can explore?

    image.png

    Is the “ select base on cube” something I have to do, or it’s automatic?

  • Zayaan Wasif
    Zayaan Wasif Employee
    10 Comments Level 300: Expanding Board in Your Organization August Badge of the Month First Answer

    Hi Walter,

    You'll need to configure the select manually at least once on a screen then save the configuration - from there, the select will be automatic every time you navigate to the screen. You can configure it via the Select window on the screen (In design mode so you can save it), clicking on the 'Dynamic Selection' icon for the entity you'd like to be driven by the cube and then selecting the relevant cube. The following page on the Board Manual also walks through these steps with screenshots :

    https://help.board.com/docs/dynamic-selection?highlight=selections

    I hope the above helps!

Categories