Brad Mathews Posted March 26, 2016 Share Posted March 26, 2016 (edited) 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 Link to comment Share on other sites More sharing options...
comment Posted March 26, 2016 Share Posted March 26, 2016 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. . Link to comment Share on other sites More sharing options...
Brad Mathews Posted March 27, 2016 Author Share Posted March 27, 2016 Comment, That does it, you rock! It also worked, of course, to get related siblings on the Students layout. - Brad Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2924 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now