General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Erik,
Thanks for the reply. I'll look into that... When I edit the RI code will I have to save my changes somewhere in case I regenerate the RI code?
Thanks
>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only