Advanced Limiting in Global Update

In Global Update, you can refine a search and reduce the number of records retrieved by using advanced limiting. Advanced limiting enables you to use Boolean search conditions and specify multiple criteria by which to limit.

Choose Global Update from the Function list.
Retrieve a group of records.
Choose Tools | Limit from the menu.
In the Advanced Limit dialog box, choose the Append Line button.
Enter the data by which to limit:

Type	Enter a record type
Field	Enter a field from the chosen record type
Condition	Enter a Boolean search condition
Value A	Enter the data by which you want to limit
Value B	If you selected a Condition that requires a second limit value (e.g., between), enter that data in the Value B cell.

(Optional) Specify additional limit criteria.
(Optional) Delete limit criteria.
Choose OK to close the Advanced Limit dialog box.
Choose the Search button located at the top of the Select records tab to apply the limit to the records in the browse list. Your limit criteria appear in the status bar at the bottom of the application window.

Clearing Limits from Subsequent Searches

The limit you create applies to all subsequent searches in the current session unless you clear the limit. To clear the limit, choose Tools | Limit from the menu and select the Clear All button in the Advanced Limit dialog box.

Specifying Additional Limit Criteria

To specify additional limit criteria:

Specify your criteria for the first limit.
Choose the Append button to add a limit criterion after the last criterion in the table or choose the Insert button to add a limit criterion before the selected criterion.
In the Operator cell of the new limit criterion, choose "and" or "or."
Specify the criteria for the new limit.

You can create an unlimited number of limiting criteria.

Deleting Limit Criteria

To remove a limit criterion from the table:

Select the row or rows of the limit(s) you want to remove.
Choose the Delete button to remove the selected row(s).