Simon Bowler Posted January 7, 2002 Share Posted January 7, 2002 FMP documents well how to create a search then add to it by getting a new search (ctrl "N") from the request menu - if necessary ticking the "omit" box. I want to do the same thing in a script to include certain values from one field, but exclude values from another - eg everyone from City A who is not Occupation B. I want to use the results of a global field to define the "include" criteria so I cant "pre-setup" the search. Can anyone help me with the script steps ? Link to comment Share on other sites More sharing options...
BobWeaver Posted January 7, 2002 Share Posted January 7, 2002 When you are in find mode in a script, the following script steps behave as follows: New Record/Request - Creates a new find request Omit Record - Changes the current find request to an "Omit" request. So if you want to find all records where field x="hello" and field y "goodbye" you would do this: code: Enter Find Mode [ ] Set Field [x, "hello"] New Record/Request Omit Record Set Field [y, "goodbye"] Perform Find [ ] Link to comment Share on other sites More sharing options...
Simon Bowler Posted January 8, 2002 Author Share Posted January 8, 2002 Many thanks - obvious really SB Link to comment Share on other sites More sharing options...
LiveOak Posted January 8, 2002 Share Posted January 8, 2002 Make sure that the status area is toggled to "show", otherwise the Omit script step will not work! Not so obvious. Toggle Status Area (Show) -bd Link to comment Share on other sites More sharing options...
Thom Posted January 8, 2002 Share Posted January 8, 2002 LiveOak, I tested this a bunch of different ways, and the state of the Status Area made no difference at all. I'm using FM 5.0v3. Can you send me a demo file where a hidden Status Area causes an Omit Record step to malfunction during a find? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8143 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