SanderS Posted March 23, 2006 Share 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. Link to comment Share on other sites More sharing options...
Ender Posted March 23, 2006 Share 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, Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6747 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