Can you post the script? For example, if you want to find everyone in California, then only show the people in Los Angeles, you should be using Constrain in your second find request. One way:
Perform Find (Restore) <<your find criteria
Constrain Found Set (Restore) <<your omit criteria
I don't see constrain as an option when in the script mode. I guess it is the same as omit?
I am simply trying to create a script where I have two AND finds and an additional one that omits certain records in the found set and the two and finds. In other words. all members who are active and live in the US. Then omit the ones who do not want to be on the printed list.
I have three fields
status which is active or inactive
country which is US or foreign countty
do not print which is yes or no.
so. i am finding active, US and then I want to omit the do not prints but i cannot get the script step to allow an omit and overtime I add a new step it also places it first in order. I am sure this a simple thing but I cannot get it to work.
There is more than one way to do a Find in a script. The shortest is to use only the one step:
Perform Find [ Restore ], with the "requests" within it, seen by double-clicking on that step. You see each Find Request, and any Omit Requests as the last line(s). The must be as the last lines; as any regular find after an "omit" would overwrite it's attempt.
I used a database I have to show these tests, so the names are different; but I think these are similar to your Find. These both work the same (and as expected).
One script step:
As multiple script steps; takes up much more room, but is more easily readable (if you're going thru looking at a script).
I know this is going to sound idiotic, but I cannot get the omit to show up.
I do a perform find or enter find mode (either one) script step
I click on find all active members. then when I try to do add a request to add another field to omit it just adds an AND or it reverts the original find request to omit. I am at wits end here. I have tried everything I know how to do to make the second request show as omit, but it refuses to do so. I have another script where the omit step is working, so i have done this before, but I have been trying for hours to do this.
I was able to use the longhand approach and get it to work. I cannot thank you enough. It doesn't explain why the "shorthand" version would not omit a record, but that will be for another day. Again, many many thanks for your help.