Thanks Cathi :)
>Try using the ResumeBinding method of the CurrencyManager after the update and acceptchanges.
>
>>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
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>