Cathi,

I have noticed that when I add the new row to the child table the relation get disturbed and also spoiles the databinding !!

As I said befor for updating the data I am using this code

Me.BindingContext(myDS, "Member.MemMsr").EndCurrentEdit()
myMeasureDA.Update(myDS, "Measure")

- "Member.MemMsr" is the relation
- "Measure" is the relation

Any suggestions ?


>Add the new row to the child table and not the relationship.
>
>>Dear All
>>
>>What is the correct method when you have a parent table and child tbale and datarelation between them?
>>Adding the new Row to the child table as :
>>

>>myDS.Tables("Member").NewRow()
>>

>>
>>Or adding the new Row to the relation as :
>>
>>

>>myDS.Tables("Member.MemMsr”).NewRow()
>>

>>
>>Thanks for the advice