, it is a one-to-many relationship. If both ends are marked with a 1, it's a one-to-one relationship.You can use a single delete query to delete records from a single table, from multiple tables in a one-to-one relationship, or from multiple tables in a one-to-many relationship, if cascading deletes are enabled (for example, all customers from Ireland and all their orders). However, if you need to include the "many" table along with the "one" table, in order to add criteria, you must run the query twice, since a query cannot delete records from the primary table and the related tables at the same time.
You can distinguish a one-to-many relationship in query Design view by looking at the joins between tables. If one end of a join is marked with the infinity symbol , it is a one-to-many relationship. If both ends are marked with a 1, it's a one-to-one relationship.
Return to Delete a group of records with a query