Microsoft Office Tutorials and References
In Depth Information
When deleting records, Access checks your relationships to
ensure that you are not deleting data that would cause any
inconsistencies in your database.
Delete a record
1 Click the record selector, and press Delete to delete the highlighted
2 In our example, the record cannot be deleted, and this results in a
warning message. Click OK.
3 Click the expansion symbol (+) beside the record selector to show
the related records.
(continued on next page)
CAUTION If you attempt to delete a record that has related
records in child tables, depending on how you have set the
relationship, either you will be unable to delete the record because the
relationship prevents this or, if the relationship has a cascade delete,
you will see a warning advising you that related data in other tables
will be deleted.