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.