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.

Display record from unrelated table

bigmac
in Relationships

Featured Replies

I have 2 different tables.

I want to display a calculated value from table 1 in table 2. I first did this by making the value in table 1 global. Worked OK, but the value did not update correctly.

When i made it non stored calculation, I could not show the value because the tables were unrelated.

I have nothing to relate between the tables. There is no common denominator or anything.

The calculated value in table 1 is a get(TotalRecordCount) calculation that i want to display in table 2. How?

You could create a relationship between the two tables using the "x" relationship operator which basically makes every record in one table related to every record in the other table. It doesn't matter which field you use. Then, you should be able to see all global fields whether indexed or not.

  • Author

Thanks alot. Works great.

Create an account or sign in to comment

https://fmforums.com/topic/60989-display-record-from-unrelated-table/
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.