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.

Global Calculation Field as Relationship reference issue

Don_Macaroni
in Relationships

Featured Replies

I have a global calculation field which acts as a reference for a relationship... But it doesn't work.

If I use a global number field and enter the same data manually as is calculated in the global calculation field, the relationship works just fine. Weird or am I doing something wrong?

As I am making a touch screen solution, a four digit sequence ( eg. 2395 ) is made up out of 4 global fields ( eg. field_one & field_two & field_three & field_four ). Each global field can be manipulated by a plus and a minus icon, going up and down from 0 to 9. Very simple, works fast and flawless. Except for the generated number not making a match with related table.

Anybody?

post-94185-0-16694600-1348233442_thumb.p

Most likely, your calculation's result includes some extra characters (e.g. a space) that prevent a match.

  • Author

I just found a typo... very stupid. Been working on this complex database for 5 hours straight and I guess I need to rest a little.

Thanks.

Create an account or sign in to comment

https://fmforums.com/topic/86168-global-calculation-field-as-relationship-reference-issue/
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.