By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,393 Members | 1,405 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,393 IT Pros & Developers. It's quick & easy.

Cascade delete of indirect children records

P: n/a
I am looking for a way to delete indirect children records when a root
record is removed. The same action that occurs if you delete a
directory that contains sub directories of sub directories.

The Relationship Integerity and Cascade Delete features works well
with direct relationships, but I can't get it to work for my
situation.

For example:

Product A
---Product B
------Product C
Product D

If I remove Product A, I want to remove products B and C. The Cascade
Delete will remove product B, but not product B's children.

Is this possible with Access 2000 or will I need to do this
programmically?

Thanks in advance!
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
If you have ProductA cascaded to delete ProductB and ProductB cascaded to delete
ProductC, then deleting ProductA Will delete ProductC!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"James" <co*********@hotmail.com> wrote in message
news:fb**************************@posting.google.c om...
I am looking for a way to delete indirect children records when a root
record is removed. The same action that occurs if you delete a
directory that contains sub directories of sub directories.

The Relationship Integerity and Cascade Delete features works well
with direct relationships, but I can't get it to work for my
situation.

For example:

Product A
---Product B
------Product C
Product D

If I remove Product A, I want to remove products B and C. The Cascade
Delete will remove product B, but not product B's children.

Is this possible with Access 2000 or will I need to do this
programmically?

Thanks in advance!

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.