datagrids + dataset relations.

[mike55]

Have created a dataset with two tables, myMembers and myGroupMembership. Have assigned the column Member_ID in the myMembers table as a primary key.

 

With dsDataset.Tables("myMembers")
               .PrimaryKey = New DataColumn() _
               {.Columns("Member_ID")}
           End With

 

Have created a relationship between the two tables.

dsDataset.Relations.Add(New DataRelation("relGroups", dsDataset.Tables("myGroups").Columns("Group_ID"), _
                                                                           dsDataset.Tables("myGroupMembership").Columns("Group_ID"), True))

 

I now want to bind the result of the two tables to a single datagrid... question is how??

 

Mike55