Question on deleting records

  • Thread starter Thread starter C Tate
  • Start date Start date
C

C Tate

What is the quickest and easiest way to discover if records in a related
tables are being deleted when you delete a record from a single table?

I ask this because a database I am using seems to have very odd
relationships. As far as I can see there are no one to many relationships
but some of the tables do seem to be linked by thin lines.
 
If you are wondering or concerned about what the relationships are doing,
you can use the Database Documenter, select the tables of interest and
select the option to document Relationships. The documenter will provide
all the properties of that relationship and tell you whether referential
integrity is enforced, etc.

In addition, if Cascade Delete Related Records is set, you should normally
see a prompt which tells you that if you delete the record, additional
records in a related table will be deleted.
 
Back
Top