« How can I subtract numeric data from two database table in Microsoft Access?
How can you access remote files from work with Windows Vista? »

How to delete records and related records in an Access database.?

Can anyone explain *as simply as possible* how to delete records with their related records in access database to ensure the consistency of the database is maintained.
But, I mean I need a way that will be fool proof and definitely delete the record with all related records to it.

Any help? Thanks.

If you have correct relationships linking primary keys to foreign keys, open any relationship between two tables containing related records, and then tick the box titled "cascade delete related records". With this option selected, every time that you delete a parent record, all related records will be deleted as well, regardless of how you perform the delete.

A word of caution though. You do not always want to delete related records. A text book example would be employees and projects. Just because an employee no longer exists, if you delete that employee from the system, you would (probably) not want to delete all the projects they were working on with them.

This entry was posted on Sunday, December 27th, 2009 at 7:39 am and is filed under access database. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “How to delete records and related records in an Access database.?”

  1. Bilal Says:
    December 27th, 2009 at 12:55 pm

    there are two way to delete da record one is from da front of report where u make da option of delete record & other is on da table where ur entering da value of data
    References :

  2. Gecko Says:
    December 27th, 2009 at 1:34 pm

    If you have correct relationships linking primary keys to foreign keys, open any relationship between two tables containing related records, and then tick the box titled "cascade delete related records". With this option selected, every time that you delete a parent record, all related records will be deleted as well, regardless of how you perform the delete.

    A word of caution though. You do not always want to delete related records. A text book example would be employees and projects. Just because an employee no longer exists, if you delete that employee from the system, you would (probably) not want to delete all the projects they were working on with them.
    References :

Leave a Reply