DataRelations Link Question Win [C#]

[MikeY]

Hi Everyone,

Is it possible to link more than two tables together? My sample that works
perfectly fine (but only the two links) is as follows:

DataRelation TableDetail =
DB_DataSet.Relations.Add("EMPLOYEE_ASSIGNED_LEVELS",
DB_DataSet.Tables["EMPLOYEE_ZONE"].Columns["EMP_ID"],
DB_DataSet.Tables["EMPLOYEE_ASSIGNED_LEVELS"].Columns["EMP_NUMBER"]);



Any and all help is appreciated



Thanks

MikeY

 

[MikeY]

Yippy I found it......I think. Anyhow heres the code that I've located.

DataRelation TableDetail =
DB_DataSet.Relations.Add("EMPLOYEE_ASSIGNED_LEVELS",new
DataColumn[]{DB_DataSet.Tables["EMPLOYEE_ZONE"].Columns["EMP_ID"]},new
DataColumn[]
{DB_DataSet.Tables["EMPLOYEE_ASSIGNED_LEVELS"].Columns["EMP_NUMBER"],DB_DataSet.Tables["EMPLOYEE_INTRANET"].Columns["EMP_NUMBER"]});



I know there is also another way to do it, but, this is good for me



Thanks eveyone.