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.

intra-table relationships

chasm24
in Relationships

Featured Replies

I have a table with records of companies. some companies are related to others (like subsidiaries) and i want to be able to show this connection. i also want to show a connection between subsidiaries but don't want to be bogged down with manually inputting primary keys among 10 subsidiaries so that all the companies show up in each other's portals. any suggestions on how to proceed?

If you add a "Parent Company ID" field to the table, you can add a second TO of Company for the "Subsidiaries", where the relationship is based on Company::CompanyID = Subsidiary::Parent Company ID. To see the other companies with the same parent company, use a third TO of Company for "Same Parent", where the relationship is based on Company::Parent Company ID = Same Parent::Parent Company ID AND Company::Company ID <> Same Parent::Company ID.

  • Author

so i need to give parent companies two primary keys? Company ID and Parent Company ID?

Company ID is the primary key, Parent Company ID is the foreign key in the self-join relationship.

Create an account or sign in to comment

https://fmforums.com/topic/34109-intra-table-relationships/
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.