March 23, 200619 yr 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.
March 23, 200619 yr 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,
Create an account or sign in to comment