We added Cascade Deletes with the relationship between Services Purchase Information Cascade Deletes I have an intense dislike of cascading deletes. Especially when a user sees the Access message they don't pay any attention to the extra wording. And it can be way, way too easy to start deleting records from too many tables. For example you go to delete a customer and, whoops, cascade delete just removed all the customers invoice headers and invoice deletes. Clearly that's an extreme example but is quite possible if someone doesn't clearly understand what could go wrong.