customer + product IDs

[googoo]

I am a form based on a query, At the moment the form displays customerID, I'd like to also add the corresponding productID, so I modified the underlying request, but because I've entered customers in my database who have not yet been given a product, therefore their productID does not yet exist, my form is displaying only those customers who have also a corresponding productID!
Is there any way that I can display all the customer ID's, and those of which do not have a productID the productID label will be left blank?
Hope this makes sense!!
Thanks

 

[RickSpr]

What you need is called an "outer join". In your underlying query, in design view, double-click the join line that connects the two tables. This will give you 3 choices. Choice 1 is the "inner join", the one you get by default, which only includes a row when matching data is found in both tables. The other two choices are the "left outer join" (2) and the "right outer join" (3). I can't tell you which one you need without knowing which way you drew the join line, but chances are it's number 2. However, you can read the choices and figure it out. (The difference between the two just amounts to specifying which table is expected to be missing data.) Rick Sprague