:WAVE: hello guy...

i want to ask about data report and the solution...i have adatabases that contain several table. So usually i use adodb.recordset to create a records for my data report without create my data enviroment. it's usually link with one command. i want to created that 1 or more command that have a relation and all the command can insert into my data report...

example...

Private Function CreateRecords() As ADODB.Recordset
' Creates a disconnected recordset on the fly
Dim rsTemp As New ADODB.Recordset, i As Integer
With rsTemp
' Create Recordset Fields (Columns) here
.Fields.Append "TTNO", adVarChar, 12
.Fields.Append "Company", adVarChar, 30
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open
Do While Not .EOF
.Delete
.MoveNext
Loop
Adodc1.Refresh
With Adodc1.Recordset
Do While Not .EOF
With rsTemp
.AddNew
![TTNO] = Adodc1.Recordset.Fields(0)
![Company] = Adodc1.Recordset.Fields(5)
.Update
End With
.MoveNext
Loop
End With
End With
Set CreateRecords = rsTemp
End Function

...this is only one adodb recordset...i want to have a child command on it...can anyone help me to solve this problem...if u don'tmind...can u submit the exampleon it?