G
Guest
I can relate two tables rather easily using the following code:
dsClub.Relations.Add("Section_Data",
dsClub.Tables["Section"].Columns["SectionID"],
dsClub.Tables["SData"].Columns["SectionID"]);
Which connects the "Section" table to the "SData" table rather easily using
the "SectionID" primary key. My question is:
I need to connect an "img_tbl" table to the "SData" table that is
constrained by the "Section" table so that the rows returned in the "SData"
table constrain the "img_tble"; ie, Parent/Child/Grandchild relationship.
The tables "SData" and "img_tbl" have their own Primary/Foreign key to
connect them together called "sdID" How do I set the the Grandchild
relationship between the two?
dsClub.Relations.Add("Section_Data",
dsClub.Tables["Section"].Columns["SectionID"],
dsClub.Tables["SData"].Columns["SectionID"]);
Which connects the "Section" table to the "SData" table rather easily using
the "SectionID" primary key. My question is:
I need to connect an "img_tbl" table to the "SData" table that is
constrained by the "Section" table so that the rows returned in the "SData"
table constrain the "img_tble"; ie, Parent/Child/Grandchild relationship.
The tables "SData" and "img_tbl" have their own Primary/Foreign key to
connect them together called "sdID" How do I set the the Grandchild
relationship between the two?