I have searched on the forums but cannot find an answer...

I am having trouble with finding records that are in a previous found set. I have already set up one way of marking other records in a different found set.

The way that I have set up this other refind is:

The ID of records found in an initial find are stored, line by line, in a global field. To refind these records a script loops through the global field, parsing out each ID and setting it into the ID search field in the new requests..

The script sort of works, except for the last line of the global -- which means that sometimes the refound set misses the last record.

An example file is attached.

Can anyone help with this

Refind.zip

A good technique for remembering found sets is to copy the ids with the Copy All records script step, then use that in a self-join relationship to return.

Cobalt Sky did a nice job explaining this technique in this thread:

http://www.fmforums.com/threads/showflat.php?Cat=0&Board=UBB6&Number=125374

I also posted a simple demo that uses this technique here:

http://www.fmforums.com/threads/showflat.php?Cat=0&Board=articles&Number=101576

Note that this has limitations to the size of the found set it will store, because of the character limit for a field (I can't recall what that limit is.)

Ender

Thanks for the links

efen