May 27, 200421 yr What is the easiest way of saving a found set which can be called back at a later stage??? Thanks Simon
May 27, 200421 yr 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
May 27, 200421 yr 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.
May 27, 200421 yr You have to be careful that the found set doesn't exceed 64000/(length of serial + 1) or it will fail.
May 28, 200421 yr 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.
May 28, 200421 yr 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
June 1, 200421 yr Sorry, Lee. Try a search on 'SAVE'. I'd attach a copy but I don't like to do that without JMO's permission.
Create an account or sign in to comment