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.
