>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
Set up a relationship in the dbc for the tables in question, and use the RI wizard to generate RI code. You can then look at the code it generates to decide if you would like to modify it to ask for user confirmation.
Erik Moore
Clientelligence