Repeated results (1 Viewer)

I have a query based on one table (Customers) and two other queries. (Orders) and (Invoices)

I have a function in the criteria of the new query which selects the customer but the results are repeated !

For 1 invoice i see 6 records of the same invoice.

Is it anything to do with (Output all fields)?

Please help.

The Joins between tables in the grid are wrong,

The problem is that Customers has a 1-to-many relationship with orders and Customers has a 1-to-many relationship with Invoices but Orders and Invoices have no relationship. Therefore, to explain your output - you are seeing 6 invoice rows because the Customer has 6 Orders. If you are not selecting any columns from Orders, remove the table from the query.