How to bind them into an ADO recordset?

[opposite99]

This is an invoice program. I created a data Environment whereby cnmain1 is a command and cnmain2 is a child command. How can I bind both of them into a ADO using SQL statements?

cnmain1 consists of
orders.InvoiceNumber (where orders is the table, InvoiceNumber is the field)
orders.InvoiceDate
orders.CustomerID
Customer.Name
Customer.Address
Customer.Phone

and cnmain2(child command) consists of
Item.ItemNumber,
Item.Desciption,
Item.Price
OrderItem.Quantity
Orders.InvoiceNumber

Item.ItemNumber = OrderItem.ItemNumber AND Orders.invoicenumber = Orderitem.invoicenumber


Thank you.