>Thanks Borislav for your response. It clears it up for me.
>
>Also, the RI that you mention I've never used before. I just played around with the RI builder and noticed that it only is available with a database that has what i think are called "persistent" relationships between the tables. I always like to make my table relationships on the fly, so to speak, as they are needed rather than made in the database designer.
>
>Do you find it is better to use the RI builder or write the code to delete all child records manually? Is there a way to use the builder without having the relationships between the tables made in the database designer (it looks confusing for me and I like to keep things simple).
>
>Thanks again!
>
>Paul
The benefit of using RI is that they permanent once set up and you don't have to program anything. Also if the data are accessed outside the application, then you don't have to worry of messing them up.
If it's not broken, fix it until it is.
My Blog