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.
"MikeY" <mi*******@yahoo.comwrote in message
news:e0**************@TK2MSFTNGP06.phx.gbl...
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