Many to Many | Community
Skip to main content
C
CharleyGBD
June 2, 2016
Solved

Many to Many

  • June 2, 2016
  • 2 replies
  • 2265 views

Hello,

I'm trying to create a many to many cardinality relationship between two tables.

I can't find any information about how to do that.

Can you help me out please?

Thank you!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Linda_Stinson

    You need to create an intermediary table to store the relationship and any other attributes that you want to add to qualify the relationship. Example of this can be found in the out-of-the-box schemas in the Operators access rights on folders table.

    The N:M table will have a 1:N link to each of the two entities involved in the relationship and will have one entry for each such relationship.

    Linda

    2 replies

    Linda_Stinson
    Adobe Employee
    Linda_StinsonAdobe EmployeeAccepted solution
    Adobe Employee
    June 2, 2016

    You need to create an intermediary table to store the relationship and any other attributes that you want to add to qualify the relationship. Example of this can be found in the out-of-the-box schemas in the Operators access rights on folders table.

    The N:M table will have a 1:N link to each of the two entities involved in the relationship and will have one entry for each such relationship.

    Linda

      C
      CharleyGBDAuthor
      June 3, 2016

      Thank you so much Linda!

      Charley

        Terms & ConditionsAccessibility statement

        Loading footer...