In the page heading, select the Select Query box, and then select Delete Query.
If your query contains one query source, the source is selected as the target source.
-or-
If your query contains more than one query source, the Target Query Source window appears.
On the Target Query Source window, select a source from the sources on the canvas, and then select Add.
Note: If the query contains more than one query source, the query sources that you do not select are removed automatically from the design canvas.
The Conditions section is updated to include the following rows:
- Field
- Table
- Criteria
- Or
For the fields that you want to delete, in the Criteria cells, create expressions to specify criteria for the record deletion. Any record that meets the specified criteria will be deleted.
For example, if you want to delete Motor records for which the manufacturer is WESTINGHOUSE, you can create the expression 'WESTINGHOUSE' in the Criteria cell for the Manufacturer field in the Motor family.
In the page heading, select
A dialog box appears, indicating how many records will be deleted by the query.
To perform the deletion, select Yes.
-or-
To stop the deletion, select No.
Depending on your selection, the deletion is performed or stopped.