Microsoft Access Cascade Update 

If you've ever received the warning message, "The record cannot be deleted or changed because table 'tblYourTableName' includes related records," you've experience 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.
www.trainsignal.com/Microsoft-...