Cascade delete of indirect children records

[James]

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!

[PC Datasheet]

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!