queries on check fields

[John thomas]

Hi I am a complete beginner all was going well i have a data base that works .but i have hit a problem that must be stupidly easy to solve
I have a customer table and a order details table i have a check box in order details table .
I want to find all my customers who have never ordered ,so i put the surname from he customers table in first querie field and ordered which has the checkboxfrom the order details table in the 2nd box in the criteria i write false .It returns no customers at all which is wrong if i leave the false out it returns customers .i have tried putting true but just the same .all help welcome
Dave

 

[MStef]

Look at "DemoCustomersOrderA2003.mdb" (attachment, zip).
Look at Tables, Relationships, Query.
Open query and try.
If You want to see a customers who have no orders, you must
to change a RELATIONSHIPS IN THE QUERY.
Put "Join properties 2", "Inculude ALL records from "Customers" and only
those records from "Orders" where the joind field are equal".
Look at "criteria" in query (f1IDOrder field).