Many to Many Same Table

[rivet]

I would like to create relationships between an account and other accounts.

I have created a table called role. Assuming that the best way is a join table. Plus I would like to give a description of the relationship.

Now I am just not sure how to have the portal view the information properly.

So if accountA has a relationship with AccountB and AccountC. I should see A in B and C's portal, and B and C in A's portal.

Any suggestions.

[rivet]

found a thread http://fmforums.com/forum/showtopic.php?tid/171427/

which inspired a solution.

many2manySameTable.fp7.zip