I have the code on how to create a query but I'm not sure how to tell the textbox to list the specified field. Ex. Here's the tables.
customer_ID Primary Key
order_ID Primary Key
customer_ID (Foreign field)
"SELECT FROM tblCustomers LEFT OUTER JOIN tblOrders ON tblCustomers.customer_ID=tblOrders.customer_ID WHERE tblCustomers.customer_ID=" & txtID & "
I don't know how to put it in the text boxes so that they know what field to return info from. I tried tblOrders.customer_ID but that didn't work. Do I have to create a seperate SQL statement inside the original SQL statement? Will this cause any problems?