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.

Table occurrences in Relationships

tomp
in Relationships

Featured Replies

I'm developing an FM7 application.

One table - Charges - currently has two relationships originating from it - one to another table in the same file and the other to a table in another file. The linking field is different for each.

The 'name of table occurrence' for both is 'Charges'.

I'm trying to add a 3rd relation originating from this same table. The linking field is again different and it will link to a 3rd table in a 3rd file.

FM7 insists on making the 'name of table occurrence' for this 3rd relation 'Charges 2'.

Why the '2'? What significance should I attach to this?

TIA

A second TO is required to break a circular relationship. Is there a relationship in one of the ther files between the 2nd and 3rd files?

  • Author

Thanks. I'm slowly beginning to understand what FM7 is all about from this and another thread I started

Create an account or sign in to comment

https://fmforums.com/topic/30730-table-occurrences-in-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.