Setting OMIT/Include in script during a Find script.

October 17, 201114 yr

Ok, I'm working on the script below. I've been searching the forums and trying to figure out how I can make my second request in the find be a OMIT instead of an include find. Basically I want to find all records with an Assurance Flag = "No" and in the region the user selects from the custom dialog box and then omit any of those records that have "NONE" as their Assurance form letter number. I feel like I should know this but I can't seem to find the answer. Any help would be appreciated. Thanks.


Freeze Window

Enter Find Mode [ ]

Go to Layout [ &#8220;Layout #18&#8221; (DA_Master_list) ]

Set Field [ DA_Master_list::Assurances Flag; "No" ]

Show Custom Dialog [ Title: "Select Region"; Message: "Which Region do you want to view"; Buttons: &#8220;OK&#8221;; Input #1: DA_Master_list::Region,

"Region #" ]

New Record/Request

Set Field [ DA_Master_list::Assurance_Form_Ltr_num; "None" ] *** How do I set this request to OMIT instead of Include ***

Perform Find [ ]

Sort Records [ Specified Sort Order: DA_Master_list::Dname; ascending ]

[ Restore; No dialog ]

Refresh Window

[ Flush cached join results ]

October 17, 201114 yr


New Record/Request

Set Field [ DA_Master_list::Assurance_Form_Ltr_num; "None" ]

Omit Record

In find mode, Omit Record script step works just like checking the Omit box in a manual find request. (Actually it toggles the checkbox, but you are starting from an unchecked state anyway.)

October 24, 201114 yr

Author

New Record/Request

Set Field [ DA_Master_list::Assurance_Form_Ltr_num; "None" ]

Omit Record
In find mode, Omit Record script step works just like checking the Omit box in a manual find request. (Actually it toggles the checkbox, but you are starting from an unchecked state anyway.)

Thanks I will try that. I figure is was something that I overlooked. I just couldn't put my finger on the solution.

Paul