Really interesting problem !
-
Foll are the output of the Structure of DataSet after reading it from a Schema file, with the Relations. Tables count=3 TableName='Calls'. Columns count=1 ColumnName='Calls_Id', type = System.Int32 TableName='Call'. Columns count=5 ColumnName='DateTime', type = System.String ColumnName='TSR_ID', type = System.String ColumnName='Comments', type = System.String ColumnName='Call_Id', type = System.Int32 ColumnName='Calls_Id', type = System.Int32 TableName='Evaluation'. Columns count=4 ColumnName='MonitorName', type = System.String ColumnName='DateTime', type = System.String ColumnName='Evaluation_Id', type = System.Int32 ColumnName='Call_Id', type = System.Int32 RelationName='Call_Evaluation Parent Table= Call Child Table=Evaluation Cols=Call_Id, AND Call_Id, RelationName='Calls_Call Parent Table= Calls Child Table=Call Cols=Calls_Id, AND Calls_Id, But the problem is in the nesting. Though the relations seem to exist, but I don't think they are actually being populated that way. Here is the output after putting values in the DataSet. If you notice, the parent ID has not been populated on it's own since the relation has been defined. TableName='Calls'. Rows count=1 ColumnName='Calls_Id', value = 0 TableName='Call'. Rows count=3 ColumnName='DateTime', value = 1 ColumnName='TSR_ID', value = 62137 ColumnName='Comments', value = 1 ColumnName='Call_Id', value = 0 ColumnName='Calls_Id', value = ColumnName='DateTime', value = 1 ColumnName='TSR_ID', value = 1 ColumnName='Comments', value = 1 ColumnName='Call_Id', value = 1 ColumnName='Calls_Id', value = ColumnName='DateTime', value = 1 ColumnName='TSR_ID', value = 1 ColumnName='Comments', value = 1 ColumnName='Call_Id', value = 2 ColumnName='Calls_Id', value = TableName='Evaluation'. Rows count=3 ColumnName='MonitorName', value = OP NMay ColumnName='DateTime', value = 2003-09-10 ColumnName='Evaluation_Id', value = 0 ColumnName='Call_Id', value = ColumnName='MonitorName', value = ColumnName='DateTime', value = ColumnName='Evaluation_Id', value = 1 ColumnName='Call_Id', value = ColumnName='MonitorName', value = ColumnName='DateTime', value = ColumnName='Evaluation_Id', value = 2 ColumnName='Call_Id', value = Am I missing something here ? I really need to solve this problem asap. :doh: Thanks, Paul