Skip 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.

Performing a find within found set

ibiubu
in Script Workspace and Script Triggers

Featured Replies

I have a script in my parent file that "Goes to related record" and then runs a script in the related record that "Perform find" with constrain turned on.

Here is my question: I have about 1000 records in the related file. When the script runs, it goes to "Related record" and shows 5 related records. It then runs the "Perform find" script. But even though I have set it to a constrain found set, the script still seems to be doing a find in all 1000 records. I know this because the find it is performing is on a field that can not be indexed, and it takes forever to run the find. If it was only searching within the found related 5 records, it should go pretty fast.

Is there a better way to accomplish this?

Larry

ibiubu,

Update your profile to reflect your platform, operating system and version of FileMaker.

The link i just below your picture, the word "profile" in blue.

Lee

  • 2 weeks later...

why don't you just loop through those 5 related record...

You could use a layout in your masterfile and place a portal with the relevant data in it.

Just loop through the records in this portal and check the fields...

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

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.