Constrain (and revert to) a found set as a user types

[Steven Cappiello]

Hi there,

I have a solution in which a user is brought to a found set upon startup.

I'd like to inlcude a search box that constrains the found set as the user types, and reverts back to the found set as the user backspaces or clears the search box.

I want to constrain based on all the fields on the layout.

I've seen examples of this done with a full data table but I'm not sure how to approach it if my starting point is a found set.

Could anyone suggest how I should approach this problem?

My thinking is:

1. save the found set somehow in a variable? (?? how)

2. as the user types perform a find/constrain by finding across multiple find criteria (one for each field I want to constrain against)

3. set the new found set into a variable??

4. as the user backspaces step backward to the previous found set?:?

one thing I've never learned is how to revert to a found set, so I suppose that is going to be a big part of this..

I have a feeling I'm way off.. If anyone could guide me or point me to an example, please do.

thanks

p.s. it would be nice if I could make this feature work in some limited way for folks without FMP 10-- by adding a filter & clear button next to the search box.

[Steven Cappiello]

any thoughts on this ?

[bcooney]

Several thoughts. Why go through this? Just give the user a find layout.

Next thought. Have a look at SeedCode

and

Sumware

and

Bruce Robertson's saving found set IDs technique

[Steven Cappiello]

The reason is that I'm dealing with INCREDIBLY impatient scientists who don't want to do any work.

:-)

they want the records they need to see (which are pulled from a larger set) presented to them when they log in each day..

I then want to give them a way to filter that found set, and revert back to it..

thanks for your suggestions, I'll check them out :(

[bcooney]

This reminds me of a technique to save found sets. Basically, capture found set rec IDs, and store them in a record in a multikey field in a table of found sets. They can name them, and you can have a portal to them, so that they can easily gtrr and be back in whatever found set they want.

One downside is that new records don't add to the saved found sets.