Help..

I have two sql tables.

SELECT [CarNumber]
,[DD_Key]
,[dateService]
,[mileage]
,[Description]
,[Cost]
,[LaborCost]
,[ServiceType]
,[ServicePreformed]
,[ServiceLineNote]
FROM [dbo].[CarDescriptions]

and

SELECT [CICARNUMBER]
,[CIPSEQ]
,[CI_Key]
,[CISDC]
,[CINOTE]
,[CIPATH]
,[CITYPE]
,[CISDAT]
,[CISDTS]
,[CISUSET]
,[CISWSTN]
FROM [dbo].[PINDEXSCAN]

CarDescription is the parent in this case. I want to load two datasets with CarNumber as primary key for CarDescription and then merge PINDEXSCAN to the parent by matching DD_KEY = CI_KEY...

I am building two seperate dataset but am having the issue in merging the two resulting tables

table1Column = result_DD.Tables("Table1").Columns(1)
table2Column = result_DD.Tables("table2").Columns(2)
//
//relating tables
relation = *New DataRelation("relation", table1Column, table2Column)

result_DD.Relations.Add(relation)

Compile errors...
What am I doing wrong??

thanks

gollnick