Create a Datarelation in a dataset

[Razzle00]

Hi,

How do you create a many-to-one or one-to-many relationship in a dataset. I have this code

        ' Get the DataColumn objects from two DataTable objects in a DataSet.
        Dim parentCol As DataColumn
        Dim childCol As DataColumn
        ' Code to get the DataSet columns.
        parentCol = ds.Tables("history").Columns("code")
        childCol = ds.Tables("code").Columns("code")
        ' Create DataRelation.
        Dim relHistoryCode As DataRelation
        relHistoryCode = New DataRelation("HistoryCode", parentCol, childCol)
        ' Add the relation to the DataSet.
        ds.Relations.Add(relHistoryCode)

but is only works for unique keys in both tables. But I need a many-to one relationship here. The history table has many code values that are the same as to the code table has 1 code value that is unique.

Thanks

 

[Razzle00]

Disregard this post. I have the solution. The code file has the unique key and needed to be the parent column in the relation.