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.

Finding records without a relationship

Featured Replies

Contact records store their phone numbers in a related Phones table. While in the Contacts table I'd like a scripted solution for reducing the current found set to just those without any records in the Phones portal.

Yes, the script could loop through each record doing a test for not isvalid(Phones portal relationship), store the current Contact ID in an accumulating variable, then do a GTRR on that variable's list of Contact IDs.

Is there something more efficient that does not involve looping? I suspect there must be but haven't discovered one yet.

Any ideas? Much appreciated

  • Author

Found the answer to my own question.

Execute a Constrain Found Set script step. Configure it to omit records which have Phone portal relationship::SerialID > 1

Sometimes writing out the problem and submitting it to a forum jiggles the mind to spontaneously come up with the answer.

Thanks.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

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.