Hi.

Got a database that tracks shopfitting installations for various store groups, various brands, that are all at various stages of development. What i am trying to do is perform a find manually by brand, store group and then 'current' projects. I then want to be able to run a script that will extend the found set to include 'on hold' and 'proposal' projects. The problem is that the script then includes all other brands as well, it is not using the origonal search criteria. i know it works if i do it manually, and i have tried to follow these steps within the script - ie modify find and then extend found set

Any ideas?

Do you mean extend or constrain? if you extend the criteria, it will add any matching records to your found set.

If you want to constrain, then the current found set will shrink based on the new criteria.

Try this out if you want to find on hold and proposal projects for a specific brand and store group that you've found manually:

The script would look like....

Enter Find Mode

Set field [ field1 ; "on hold"

new record/request

Set field [ field1 ; "proposal"]

Constrain Found Set

Hope that does it!

Hi Martha,

thanks for the reply. It doesn't really matter if i extend from one of the three status' i want to find, or constrain from the full set for that brand. I have tried the script you suggested, and i must be doing something wrong. When it goes to the next find request, it ignores the inital find request data, and opens the find up to all brands. Have i missed something?

all the best

mark