Whats the easiest way to delete a record with related records?

[RedGoneWILD]

I was reading that cascade delete option will do this, but is that only if you are deleting the record right from the table?

I want to have a button click event that will delete the record and all related records...anybody have any examples or ideas on how this would work?

[weekend00]

code behind the button to delete the records table by table.

[ajetrumpet]

I was reading that cascade delete option will do this, but is that only if you are deleting the record right from the table?

I want to have a button click event that will delete the record and all related records...anybody have any examples or ideas on how this would work?

Cascade deletes must be checked in each child table of a parent table in the relationships window (or elsewhere). If you don't select this option, deleting a parent record will orphan (leave behind) child records that are sitting in all the related tables associated with that main table.

And NO, cascades can be done through forms as well, not just tables. As a matter of fact, it would be pointless for MS to even program access to delete from tables at all, considering the fact that it is standard practice not to allow end users to access raw data (thus, tables).

Make sure that option is checked for all the appropriate tables. Then delete a parent record...access will do the rest automatically.

[RuralGuy]

...If you don't select this option, deleting a parent record will orphan (leave behind) child records that are sitting in all the related tables associated with that main table.

Adam,
Assuming RI is turned on, Access will throw an error when you attempt this.

[ajetrumpet]

Adam,
Assuming RI is turned on, Access will throw an error when you attempt this.

Yes I forgot to mention. Thank you for adding that in. I'm having brain malfunction, what is RI?

[RuralGuy]

RI = Referential Integrity

[ajetrumpet]

RI = Referential Integrity

*kickstart*

OK, my CPU is back online.