Many to Many

[#1]

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!

[#2 · Accepted solution]

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

[#3]

Thank you so much Linda!

Charley