If you have ever been frustrated when trying to delete a record in Access and seeing the warning message “The record cannot be deleted or changed because table ‘tblYourTableName’ includes related records,’ do not be dismayed. That warning message is actually a good thing, for referential integrity is protected your data from being orphaned. To side-step the warning message and to allow you and your database users to delete unwanted data, you might want to try to turn on a feature called “cascade delete.”
To learn how to enable Cascade Delete, watch the following video:
Note: This video demonstrates cascade delete using Access 2007; however, the steps are the same for Access 2010 databases. That is, as long as your database is not a web database. Web databases are kind of their own thing, in many respects.