TomYoung Posted September 30, 2001 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
Anatoli Posted September 30, 2001 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.
Newbies rnigte03 Posted October 22, 2001 Newbies 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!
Newbies rnigte03 Posted October 22, 2001 Newbies 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!
Vaughan Posted October 22, 2001 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.
Recommended Posts
This topic is 8433 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