Is anyone able to tell me how to get a portal to display ONLY the current found set of records from the SAME file?

I don't want to have to insert / replace a value in the match field to identfy the currently found records each time I've done a find since it would have to be deleted again each time I do a new find / omit any of the found set.

Is there any way of creating a dynamic relationship based on the records that are members of the current found set?

I've tried self-joins based on calculations of the Get(recordnumber) but they won't work unless the calculation is indexed (which of course defeats the object of the exercise as it won't then change/update the portal records when you do another find).

Mike Owen

Hi,

You'd need a layout with only the recordIDs on it and a Copy All Records script.

Then copy the clipboard to a global field and the IDs would line ups as Carriage separated IDs allowing for a relationship to the RecordIDs in the file.

There's a demo around in the Article section by Ender that seems to cover your need. At least it could be adapted.

Preview Foundset

Or make a search for "Copy All Records" as this request is rather frequent and quite always solved with this technique.