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
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