The Delete Statement Dialog

 

 The DELETE statement is opened from the connection dialog by creating a statement on a connection, refer to .

 

The delete dialog is used to delete complete records from a table in a data source.
In the image above we have specified that all records with a 'firstname' that has BILL in it, and a 'lastname' that has any of the values returned by the select 'client-select-with-names-to-delete'. So if the select, which is normally performed on another table, returns 'BLOGS', 'BLOW' and 'DOE', then all record that have both a first name BILL AND a last name BLOGS or BLOW or DOE are to be deleted.
The expression field allows for the input of the value, which holds the data to be used for the selection of the records to delete. We need to double-click in the field to bring up the data-popup. The capabilities of the popup are explained here 

Note: The deletion of records from an ACCESS database can cause an unstable situation for the selection afterwards. Although the deletion is performed correctly, any selection afterwards on the same connection will probably cause a crash. It is recommended that the connection be re-established before proceeding.