TomYoung Posted September 30, 2001 Share Posted September 30, 2001 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 Link to comment Share on other sites More sharing options...
Anatoli Posted September 30, 2001 Share Posted September 30, 2001 Unfortunately there is not "second" find. You can restore previous find (Ctrl or Apple +R) and do more requests via additional New Request. Link to comment Share on other sites More sharing options...
Newbies rnigte03 Posted October 22, 2001 Newbies Share Posted October 22, 2001 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! Link to comment Share on other sites More sharing options...
Newbies rnigte03 Posted October 22, 2001 Newbies Share Posted October 22, 2001 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! Link to comment Share on other sites More sharing options...
Vaughan Posted October 22, 2001 Share Posted October 22, 2001 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8193 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 accountSign in
Already have an account? Sign in here.
Sign In Now