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.
Juggernaut

Seeing Both Sides of a Self-Join

mdfOffman
in FileMaker Pro 2023

Featured Replies

I have a table Doc with Documents stored with their titles.     I link Docs to other Docs showing their relationship, e.g. Doc 2 is supplemental to Doc 1.  I do this with a Join table DocLinks with 4 fields: fkDoc1, Relation 1, fkDoc2, Relation 2.  The latter 2 fields are linked to the table Doc 2.

I want to be able to see that relationship in the portal when I view Doc 2 in the main Doc Layout without having a separate portal.

How do I achieve in Filemaker the equivalent of this SQL Statement?

SELECT fkDoc1, Relation 1, fkDoc2 AS fkDoc1, Relation2 AS Relation1

Thanks for anyone's help 🙂

  • Author

You are right.  It is the same question.  I was hoping that, if I explained it more clearly, a light bulb might go off for somebody!!

42 minutes ago, mdfOffman said:

I was hoping that, if I explained it more clearly, a light bulb might go off for somebody!!

That's quite possible - but I don't think you have met your own condition...

 

Create an account or sign in to comment

https://fmforums.com/topic/109905-seeing-both-sides-of-a-self-join/
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.