Desperate help with query

[mistaking]

Hi I am new to Access, and need to know how to do the following, and if it is possible.

I have three tables

One has Supplier ID as the primary key

The next has Product Order No as the primary key
and Supplier ID as the foriegn key

The last has Supplier Invoice No as the primary key and Product Order No as the foreign key, one of the other attributes is Pay Date.

What I need to be able to do is check for each Supplier what invoices havent been paid, so i want to input the supplier ID and see all the details of Supplier Invoices that have a null value for Pay Date,

How do i go about this query??

 

[DBL]

Create a query using the three tables and drag the OrderNo and PayDate fields down to the query grid. In the Crieteria row for the PayDate field put "null". Run the query and you should see any order numbers that haven't got a paydate.

 

[mistaking]

ok thanks for the help dude, do u know any good site s with access tutorials??