Delete records by using a query that includes only the "one" table in a one-to-many relationship

When you run a delete query on the "one" table in a one-to-many relationship, and you've enabled cascading deletes for this relationship, Microsoft Access also deletes related records from the "many" side. For information on important considerations when using a query that deletes records, click .

1. Create a new query that contains the "one" table from which you want to delete records.

   How?

2. In query Design view, click the arrow next to Query Type on the toolbar, and then click Delete Query.
   
   
3. Drag the asterisk (*) from the field list for the table to the query design grid.

   From appears in the Delete cell under this field, as shown in the illustration that follows.

4. To specify criteria for deleting records, drag to the design grid the fields on which you want to set criteria.

   Where appears in the Delete cell under this field, as shown in the following illustration.

   

5. In the Criteria cell for the fields that you have dragged to the grid, type the criteria.

   For information on specifying criteria, click .

6. To preview the records that will be deleted, click View on the toolbar. To return to query Design view, click View on the toolbar again. Make any changes you want in Design view.
   
   
7. Click Run on the toolbar to delete the records.

Note   To stop a query after you start it, press CTRL+BREAK.