Skip to main content
CharleyGBD
June 2, 2016
Beantwortet

Many to Many

  • June 2, 2016
  • 2 Antworten
  • 2292 Ansichten

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!

    Dieses Thema wurde für Antworten geschlossen.
    Beste Antwort von 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 Antworten

    Linda_Stinson
    Adobe Employee
    Linda_StinsonAdobe EmployeeAntwort
    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

      CharleyGBDAutor
      June 3, 2016

      Thank you so much Linda!

      Charley

        Allgemeine NutzungsbedingungenAccessibility statement

        Loading footer...