Many to Many

CharleyGBD

02-06-2016

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!

Accepted Solutions (1)

Accepted Solutions (1)

Linda_Stinson

Employee

02-06-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