If you are doing the delete with a SP, you can add the update to it's transaction. If you are using Client side SQL then you can use a delete trigger.

BOb


>Hi everybody,
>
>I have 3 tables:

>     Cart
>        |
>         CartContent
>             |
>              CartDetail

>
>When I delete a record in CartContent, I want to delete all children in CartDetail (that's done from cascading deletes) and also update Cart.ModiType with 'D' and Cart.Modidate with getdate(). What should I do to accomplish that?
>
>Thanks a lot in advance.