A record you were attempting to delete or modify is referenced by other records

Problem

You get this error message when running your application:

Microsoft Internet Explorer

A record you were attempting to delete or modify is referenced by other records. Please see your database administrator for more information.

This error typically looks like:

This error message appears when you attempt to delete a parent record for which one or more child table records exist. These child table records have a foreign key field pointing to the parent table record you are attempting to delete.

Solution

This is not an application error. It occurs naturally when application users attempt to delete parent table records without deleting their associated child table records.