take a field, say field A.

Use field A to do a Find & omit action

This Find action produces a found set.

Problem

If you do another find (using field A), it is NOT confined to the found set produced by the first find. Instead, the second find action is applied to the whole set of records.

I've saved various finds (all using the same field) as scripts and want to run them sequentially in another script.

I'm getting nowhere at the moment.

any ideas

t

Unfortunately there is not "second" find.

You can restore previous find (Ctrl or Apple +R) and do more requests via additional New Request.

I have a similair problem:

I'm searching in two different fields with a script, say in field A and B.

In 'A' I'm searching for a department and in 'B' for a taskstatus.

So the result of a multi find in one or two scripts without manuel interaction should be:

Find in A:<department> and in B:<taskstatus>

What ever I do, I seem to get one of them but never the match of both alone at the same time. Or the results seems to be saved in an index so I get the wrong search items (e.g A=facility in A: or B: or in A: and B

After two days of trail and error haven't found the solution.

Can anyone give me the correct script sequence? and the correct meaning of 'restore before and after the paste option in the middle)?

I think the only option left is to merge the fields like <field:A&' '&field:B> than search in that field (a calculationfield).

Or is there still hope of a better solution??

Thanks!

I have a similair problem:

I'm searching in two different fields with a script, say in field A and B.

In 'A' I'm searching for a department and in 'B' for a taskstatus.

So the result of a multi find in one or two scripts without manuel interaction should be:

Find in A:<department> and in B:<taskstatus>

What ever I do, I seem to get one of them but never the match of both alone at the same time. Or the results seems to be saved in an index so I get the wrong search items (e.g A=facility in A: or B: or in A: and B

After two days of trail and error haven't found the solution.

Can anyone give me the correct script sequence? and the correct meaning of 'restore before and after the paste option in the middle)?

I think the only option left is to merge the fields like <field:A&' '&field:B> than search in that field (a calculationfield).

Or is there still hope of a better solution??

Thanks!

Rob in Holland: you should not *need* a script to perform this find, a find over two fields.

Say a db had fields "country" and "city" then to look for a city called sydney in country australia the find request would be:

city=sydney

country=australia

This is done with just one find request and it's relatively straightforward.