Jump to content

working with found set


 Share

This topic is 7608 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7608 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.