>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

But don't use these relationships if you want. Thay are not mandatory. Thay are used only for RI builder.
After you build RI you could delete them. I prefer to use RI builder, because it saves me time, but you could do your own triggers for delete, insert or update where you could code whatever you want.