Hi - I have a form with dataset with three table relationships. Table1 (master) on to many to Table2. Then Table2 is a master to Table3. I created the bindings just fine and if I have 3 datagridviews on the same form things work fine. However, I want to show table1 and table 2 on one form and then have the user click Edit to show table3 in a new form. I still want any changes to table3 to be relected in my main dataset.

This is how I am trying to show my new form:

Dim myForm As New FormEditMargins

myForm.StartPosition = FormStartPosition.CenterScreen

myForm.DsImpactTables1 = Me.DsImpactTables1

myForm.BindingSource1.DataSource = Me.DsImpactTables1.ImpactEvent

myForm.BindingSource1.DataMember = "ImpactEvent_ImpactMargin"

myForm.DataGridView1.DataSource = myForm.BindingSource1

myForm.ShowDialog()

End Sub

I get an error saying the ImpactEvent is not in the dataset.

Any ideas would be appreciated.

Scott

I solved it. I have to have an unbound datagridview in form2 and then pass the form1 data binding to form2 and configure the grid in code. I was hoping to be able to bind form2 for formating the grid, but it looks like that will not work. I have a small code example if anyone wants to see it.

I solved it. I have to have an unbound datagridview in form2 and then pass the form1 data binding to form2 and configure the grid in code. I was hoping to be able to bind form2 for formating the grid, but it looks like that will not work. I have a small code example if anyone wants to see it.