|  | Cascade Delete disabled | | |
| | | Emma Aumack |  |
|  Posted: Thu Sep 04, 2008 3:28 pm Post subject: Cascade Delete disabled |  |
I have two tables with a one-to-many relationship. Referential integrity is
enforced. Cascade delete is disabled (I cannot enable it); however, when a
record is deleted on the one side, I need to have the related records on the
many side deleted. I have already cleaned both tables so that if there is a
record on the many side, there is also a matching record on the one side.
Can I do it? How?
Please help. Thank you.
--
LINK
Tempe, Arizona |
| |
| | | Emma Aumack | |
| | Posted: Thu Sep 04, 2008 3:50 pm Post subject: RE: Cascade Delete disabled | |
Never mind.... I was looking in the front end instead of the backend.
--
LINK
Tempe, Arizona
"Emma Aumack" wrote:
| Quote: | I have two tables with a one-to-many relationship. Referential integrity is
enforced. Cascade delete is disabled (I cannot enable it); however, when a
record is deleted on the one side, I need to have the related records on the
many side deleted. I have already cleaned both tables so that if there is a
record on the many side, there is also a matching record on the one side.
Can I do it? How?
Please help. Thank you.
--
LINK
Tempe, Arizona |
|
| |
|
|
