There is a relationship between Product table and ShoppingCart table on ProductID and there is a cascade delete as well as enforce relationship for replication and enforce relationship for inserts and updates.

I have noticed that the update command on the shopping cart is not what causes the record to delete but rather the update command on the product table that causes the record in the shoppingcart table to delete. I'm not sure why this is...any ideas?

Thanks,
Paul

>Uhmmm, perhaps you might want to look at the cascade delete and update. Any error messages when you do this?