> -----Original Message----- > From: dotnet discussion [mailto:[EMAIL PROTECTED]] > On Behalf Of Shawn Wildermuth > > If you have a cascading FK in the DataSet, you should also > have one in the database.
I do..but when you are inserting, no cascades will occur on the server as the child records do not yet exist (the FK is the PK of the new parent record) ;-) FWIW the problem was due to the Update implicitly calling AcceptChanges (and thereby cascading the update to the child tables via the FK constraint, due to me using AcceptRejectRule = AcceptRejectRule.Cascade rather than AcceptRejectRule.None) Thanks for the time you spent on this problem :-) Merak You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
