If you've ever tried to delete a Microsoft Access record and received the warning message "The record cannot be deleted or changed because table 'tblYourTableName' includes related records," you've experienced one of referential integrity's safeguards; Microsoft Access is protecting your data from being orphaned. If you really need to edit a related record, you might want to turn on a feature called "cascade update." Watch this video to learn more.
http://www.trainsignal.com/Microsoft-Office-Training.aspx?utm_source=YouTube&utm_medium=Social%20Media&utm_campaign=YouTubeOffice%20Referral&utm_content=access%202007
