Newbies to Microsoft Access are often puzzled by a variety of warning messages, and the message “The record cannot be deleted or changed because table ‘tblYourTableNameHere’ includes related records,” is among the more common messages that frustrate beginners. Do not be discouraged. This message is really a good thing because it means referential integrity is doing its job in protected your records from being orphaned.
Still confused? Watch the following video to learn more: