Hi Cathi,
I fixed the datarelation problem. But it’s spoiling my databinding, when I add this line to my datagrid:
Me.dgMeasurements.SetDataBinding(myDS, "Member.MemMsr")
This is the code, I think I am missing somethign some where??
myDA.Fill(myDS, "Member")
myMeasureDA.Fill(myDS, "Measure")
‘ Add DataRelation the DataSet
myDS.Relations.Add("MemMsr", myDS.Tables("Member").Columns("MemberID"), myDS.Tables("Measure").Columns("MemberID"))
' cbSelect Member DataSource
Me.cbSelect.DataSource = myDS.Tables("Member")
Me.cbSelect.DisplayMember = "MemberID"
‘ Bind data in the first window form
Me.txtMemberName_e.DataBindings.Add("Text", myDS.Tables("Member"), "Name_e")
Me.dgMeasurements.DataSource = myDS.Tables("Measure")
‘ the next line is spoiling my next databinding
Me.dgMeasurements.SetDataBinding(myDS, "Member.MemMsr")
‘ bind the 2nd window form (*** this binding get spoiled ***)
Me.txtWeight.DataBindings.Add("Text", myDS.Tables("Measure"), "Weight")
Me.txtHeight.DataBindings.Add("Text", myDS.Tables("Measure"), "Height")
Thanks for the help
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>