Many to many self-relationship Redux

[Brad Mathews]

I am having a very similar problem to this post:

I have three tables in a standard many-many relation ship, Parents and Students and Parents_Students. I want a portal on the Parents layout that will show the other Parents related via the Students table. One way would be to put a Spouse field in the Parents table for a more traditional self relationship, but I might have more than 2 "Parents" the others being grandparents, aunts and the like. Hence the many-many self-relationship.

The answer in the post above refers to a broken link (probably from the earlier version of the forum software) and I cannot find the new link for new post.

Could someone refer me to the new post link or answer the question?

Thanks a bunch!

Brad

 

Edited March 26, 2016 by Brad Mathews
Typo

[comment]

3 hours ago, Brad Mathews said:

I have three tables in a standard many-many relation ship, Parents and Students and Parents_Students.

I don't think the other post is relevant to your situation.

 

3 hours ago, Brad Mathews said:

I want a portal on the Parents layout that will show the other Parents related via the Students table.

One way to do this is to define a self-join of the Parents_Students table as:

Parents_Students::StudentID = Parents_Students 2::StudentID
AND
Parents_Students::ParentID ≠ Parents_Students 2::ParentID

Then add a new occurrence of Parents and relate it to Parents_Students 2 as:

Parents_Students 2::ParentID = Parents 2::ParentID

Place a portal to Parents 2 on a layout of Parents.

.

[Brad Mathews]

Comment,

That does it, you rock!

It also worked, of course, to get related siblings on the Students layout.

- Brad