I have a situation where I need to delete records that may have many related records.

One way I have been tossing around in my mind is if I select a record that may have records in several other tables and to a SELECT to find them then present the info to the user in a message box with the option to cancel. If the say go then delete the records. I guess at some point you would pack the tables ...

What is a good way to do this?

John