DataRelation Prevent my DataSet Updates!!

[adsc]

Hi All,

I have 2 datatable in my dataset and have created a datarelation between the parent & child datatables.

If I updated the parent table, the data saved fine, but if updated child table it updates fine (if one row in the relation) but if it has more than one row it egnores the update & does not give any error too. Usig this code:

BindingContext(myDS, "Measure").EndCurrentEdit()
myMeasureDA.Update(myDS, "Measure")
myDS.AcceptChanges()

It woks fine if I removed the datarelation before the update !!!

myDS.Relations.Remove("MemMsr")
BindingContext(myDS, "Measure").EndCurrentEdit()
myMeasureDA.Update(myDS, "Measure")
myDS.AcceptChanges()

But I need the relation, any one knows how to solve this essue.

Note: I am using CommandBuilder & MSDE as backend database.

Thanks for the help