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.

Getting the number of related records

Mandu
in Relationships

Featured Replies

I want to find out, from a script in DB1, if there's already a related record in DB2 and, if so, refuse to invoke an external script in DB2 to add a record. In addition, if there are two or more related records, I want to be able to put up an error message.

The relationship is to a Customer database and is based on telephone number.

What is the easiest way to find out how many related DB2 records there are to the current DB1 record?

Thanks for your consideration,

Chap

If [isEmpty(relationship::serial)] <-- there is no related serial, so no related records exist

Perform Script [External]

Else

If [Count(relationship::serial) > 1] <-- the number of related serials is greater than 1

Show Custom Dialog ["Error: 2 or more related records already exist."]

Else

Show Custom Dialog ["A related record already exists."]

End If

End If

  • Author

Thanks! :-)

Create an account or sign in to comment

https://fmforums.com/topic/26337-getting-the-number-of-related-records/
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.