Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Many to many self-relationship Redux

Brad Mathews
in Relationships

Featured Replies

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 by Brad Mathews
Typo

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.

.

  • Author

Comment,

That does it, you rock!

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

- Brad

Create an account or sign in to comment

https://fmforums.com/topic/99399-many-to-many-self-relationship-redux/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.