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.

Self Referencing Relationship

Spidey
in Relationships

Featured Replies

Hi just read a database book about solution to many to many relationship. One of them is "self referencing". I am just wondering if it is possible in FileMaker. If it is not, what other solution is available? Thanks.

K.C.

Yes, self-joins work. What are you trying to do?

Hi just read a database book about solution to many to many relationship. One of them is "self referencing".

I am not sure you got this part right. A "self referencing" relationship (commonly called a "self-join" in database parlance) is a relationship between a table and (another instance of) itself. Such relationship can be one-to-many or many-to-many - same as a relationship between two different tables. So a self-join is NOT a "solution to many to many relationship".

In any case, self-joins - whether one-to-many or many-to-many - CAN be implemented in Filemaker.

Create an account or sign in to comment

https://fmforums.com/topic/75029-self-referencing-relationship/
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.