ACC2000: dealer order form with last yr qty

[A Man]

I want to print a dealer order form with all products on it. I want the
total of each product the dealer ordered in 2007 to be in a different
column next to the product. I am having problems getting the results I
want. Here are the tables I have:

*=key field
- Customer table
Fields:
o CustomerNumber*

- OrderDetail table
Fields:
o CustomerNumber*
o ItemNumber*
o QtyPurchased2007

- ItemIndex table
Fields:
o ItemNumber*
o ItemDesc

I tried linking the tables various ways using inner and outer joins, and
join option 1. Nothing gives me (in the query) all products for a
customer.

I thought I might start with the ItemIndex table and join like this:
ItemIndex!ItemNumber -> OrderDetail!ItemNumber, OrderDetail!
CustomerNumber -> Customer!CustomerNumber

But that did not work (I only got items purchased, I need to show all
items.)

Thank you.