Implementing A Data Relation Using VB And MS Access

[Developer Dude]

Hi:

I have coded a data relation for a dataset with two datatables, "SE" and "CS". The "SE" Table is

the parent and the "CS" is the child. The data relation does not work. The code to dispose of the

data relation does not work.

Thanks .... John

Create Data Relation

dsPSB.Relations.Add("SE_CS", dsPSB.Tables("dtSE").Columns("SE_KEY"), dsPSB.Tables("dtCS").Columns("CS_KEY"))


Create The "CS" BindingSource

bsCS.DataSource = dsPSB
bsCS.DataMember = "SE_CS"

Code To Dispose of the Data Relation when the child form closes.

dsPSB.Relations.Remove("SE_CS")
dsPSB.Tables.Remove("dtCS")

Continue reading...