I am trying to build a form, which will be an Invoice when I sell a product.
I have 3 tables called tbl_Customers, tbl_COrders & tbl_Parts and I have created a SELECT query with all the fields I need for the invoice. (see image).
I have created a Form which will eventually be my invoice.
When I execute the query all the fields populate the form except the customer address details?
I have foreign Key in the tbl_COrders that is one to many with the tbl_Customers table, so I expected that it would link and get the address details from there?
Can anyone see why this is not working?
I have 3 tables called tbl_Customers, tbl_COrders & tbl_Parts and I have created a SELECT query with all the fields I need for the invoice. (see image).
I have created a Form which will eventually be my invoice.
When I execute the query all the fields populate the form except the customer address details?
I have foreign Key in the tbl_COrders that is one to many with the tbl_Customers table, so I expected that it would link and get the address details from there?
Can anyone see why this is not working?