Scripting an "and" for a found set
How do i script an "and" for a found set?
I want it to find every thing that has the field "ok to clear" and "pending" checked. The 1 is Boolean and the x is a place holder...
If i put them together in the script like i have it below, it will only find the items that have both checked.
- Go to Layout [ “Clear Invoices” (Invoice) ]
- Enter Find Mode [ ]
- Set Field [ Invoice::INOkToClear_calc; "x" ]
- Set Field [ Invoice::INPending; "1" ]
- Perform Find [ ]
- Sort Records [ Specified Sort Order: Invoice::INShipmentDate; ascending ] [ Restore; No dialog ]