SanderS Posted March 23, 2006 Posted March 23, 2006 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.
Ender Posted March 23, 2006 Posted March 23, 2006 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,
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now