Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6820 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I have setup a database that lists records in a filtering method via internal relationships. I would like to be able to include the current found set as one of the filtered sets. However I can't find anyway of determining what is the found set as there is no way of "Getting" that information. I suppose i could have a mark records script included in every find but that would slow down the dbs quite a bit and I want this to be fairly seamless.

Does anyone know of a way to determine what records are found and which records are omitted at any given point in time.

Posted

In FM8, this can be done by just using the primary ID in the relationship, and using the "Match all" option in the Go to Related Records [] step.

In prior versions, you would need to build a multi-key of all the IDs of the records in the found set. This can be done with a Set Field[] loop (appending the record IDs to a global text field,) or by using the Copy All Records script step (copying from a layout with only the record ID field and pasting that into the global,) then using that global as the relationship key,

This topic is 6820 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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