Saving a found set

[simoncpage]

What is the easiest way of saving a found set which can be called back at a later stage???

Thanks

Simon

[Lee Smith]

Hi Simon,

You can always mark the records in some manner. I use a method similar to the one demostrated in a file by CobaltSky a.k.a. Ray J. Cologon called "Custom Record Selection System" which you can download from his site: http://www.nightwing.com.au/FileMaker

HTH

Lee

[TerenceM]

You can also use the "Copy All Records" script command to make a saved set. First, create a layout with a single field on it that uniquely identifies the record (serial number or such). Then, create a script that freezes window updates, switches to the new layout, copies all records, and paste the result into a storage field. In some applications, its useful to have a separate table of saved search results that can be recalled as desired. To retrieve the set, create a relationship between the save field (which contains a list of all serial numbers in the found set), and use Go To Related Records (show only related records) to retrieve the set.

[simoncpage]

Thanks guys! works a treat!

[-Queue-]

You have to be careful that the found set doesn't exceed 64000/(length of serial + 1) or it will fail.

[Oldfogey]

Have a look at John Mark Osborne's "PEOPLE" - http://www.databasepros.com/

[Vaughan]

One of the issues I always wonder about with "saving found sets" is, what happens if one or more of the records are deleted? What happens is new records are created that would be included in the found set?

I guess I'm thinking about the difference between saving a found set, and saving the find request.

[Lee Smith]

Hi Oldfogey,

I didn't remember a solution called People by JMO, so I did a search for PEOPLE at his site and got a lits of 32 files, but none were called People.

Could these be the files that were included with "List Portal" and "List Portal 2"?

Lee

[Oldfogey]

Sorry, Lee. Try a search on 'SAVE'. I'd attach a copy but I don't like to do that without JMO's permission.