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.

Calculations as match fields in relationships....

VickyN
in Relationships

Featured Replies

Please can someone straighten me out on this one.......

From what I was aware you were not able to use calcs as match fields in relationships....This is what I have been told.

Although I have by default done this and it worked. Please can someone explain to me why I was told this and the reasoning behind it!!! Life would be easier if this was possible! I hope whoever taught me this was wrong!

If your calculation is STORED then you can use it as part of the relationship key.

If the calculation is UNSTORED then that is where there are limitations.

An unstored calculation can be used on the PARENT side of the relationship. It can NOT be used on the CHILD side of the relationship.

Hope this clears it up for you.

Even STORED calculations must be INDEXED to make a key field. If indexing is switched off it will fail.

Create an account or sign in to comment

https://fmforums.com/topic/66249-calculations-as-match-fields-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.