Skip to main content
CharleyGBD
June 2, 2016
Solved

Many to Many

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.
    Linda_Stinson
    Linda_StinsonAccepted 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

    View in thread

    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

    Translate
      CharleyGBDAuthor
      June 3, 2016

      Thank you so much Linda!

      Charley

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...