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.

Relationship / calculation problem

Sergeant Ron
in Relationships

Featured Replies

Not quite sure how to categorize this, but here goes. I have two separate databases (Files). One has a summary field that is put into a calculation to add it to another summary field and give a total. This works fine and displays the correct number. I also have another file that needs that data on a monthly basis. I have a relationship set up that uses a field in each database called cMonthYear (which is a calculation of

MonthName ( date ) & " " & Year ( date ) . This also appears to work fine with one exception. The one field that is used in the first database gives me a correct result in the native file but 1 less in the related file. even if I drag and drop the field from one database to the other its still one less. I have no idea why this is happening??? anyone have a suggestion?

Thanks,

Ron.

  • Author

Nevermind folks. I figured it out. The calc of cMonthYear wasnt entered on one record, thus throwing it off. Whew... Thanks anyway.

Ron

Since you spent an hour wondering at this, you might want to figure out how this happened, and alter your design to prevent it in the future...

Create an account or sign in to comment

https://fmforums.com/topic/50276-relationship-calculation-problem/
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.