Problem with cascade delete

L

Linda

I have a problem with cascade delete deleting all of the records on th
many side when a record in the main table (one side) is deleted.

The database has 6 tables, but these are the 3 tables I'm havin
problems with cascade delete:

Matters
Matter ID - primary
Other fields

CaseParties
Matter ID - primary
Party - primary
Other fields

CaseContacts
Matter ID - primary
Name - primary
Other fields

Matters 1:M CaseParties
Matters 1:M CaseContacts

Referential integrity is enforced with cascade update and delete.

When I delete a record in the Matters table, all the records i
CaseParties and CaseContacts are deleted, not just the records relatin
to the specific matter number.

Any help on why this might be happening would be appreciated. Than
you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top