Search Query/Filter

[Confused.com]

I have a database that has a search query that it requires within it to return order information through the searching of a customer name, i.e. to return all orders for a certain customer.

Although I have two order tables - one for order details and one for order and the customer name is in the order table, within the search for order query these two orders tables are both present and won't allow me to return the information I require as it says it is too complicated.

Is there any suggestions, or any information on the use of filters in aiding me?

Many Thanks in Advance

Confused.com

 

[MStef]

What is the PRIMARY KEY in your tables??
What is the FOREIGN KEY in ORDER DETAILS table??
What is the RELATIONSHIPS between these 2 tables??