working with found set

[caseyi]

When I use a find command and come up with, say, 10 records in my found set. How do I perform further finds that utilize just this 10 records? If I do another basic find for another record, then this record will show, but if I want to search for other records, they won;t show, since the ensuing search was on the found set of 1. Am I missing anything?

ALso, is there a way to customize my find view, so that only certain fields appear on the layout as searchable fields?

[LiveOak]

As you have discovered, each find operation in FM operates on all the records. If you want to perform successive finds, each adding to the found set, you must do a little scripting.

The basic process is to find a set of records, mark them, find some more, mark the additional records, then find the marked records.

The first decision you must make is whether this need to work in a multi-user environment. If so, creating a "marked" field in each record won't give the result you want. If two user's are marking records and then each is finding all marked records the result is a lot of running around screaming about bugs in FileMaker! If you need multi-user capability, the method is a little more complex and requires a knowledge of relationships. -bd

[caseyi]

yes, presumably by multiusers. I saw some suggestions posted around sept13 "keeping found set when changing to related file". (ERC & chuck). Does this kind of scripting also not work in a multiuser environment?

[Chuck]

quote:

---

Originally posted by caseyi:

yes, presumably by multiusers. I saw some suggestions posted around sept13 "keeping found set when changing to related file". (ERC & chuck). Does this kind of scripting also not work in a multiuser environment?

---

The technique we were working with in that other thread will work in a multi-user environment, because the relationship that finds the records for you is based on a global field for the left field of the relationship. Global fields are unique to each user on the network, so each user can find all the records related to a found set without upsetting anyone elses copy of the global.

However, if you are in a multi-user setting the technique for marking records is more complicated, because you need to use a global somewhere to keep things unique to each user. I have done this before by marking records with the name of the current user (adding it if there are other uses who have marked the record, taking it out when I wanted to unmark the record), and having a global field that is set at startup to the current user, and building a relationship between the two. Then, similar to the technique for finding all the records related to the found set, you can go to the records related to your global.

Chuck

[caseyi]

sounds like I should give it a try using the scripts in the "keeing found set when changing to related files". Thanks for the suggestion!