Query leaving records out

[Waterdog]

OK, so I'm essentially trying to create a database for processing product returns. I've been having issues with the form now showing data in the subform, which holds the actual product info, and in turn the report generated isn't showing correctly. I think I've narrowed the problem down. Looking back to the basics with the queries and in turn how the tables relate to each other. For data on the subform I have a table called "tblReturnedContent". From that I've got a couple other tables linked to it. One that gives the product name and another that provides a list of reasons for the returned item. Now, for some reason when I run the query on this it'll only show entries that contain a value in the field for reason returned. Far as I can tell I don't have anything set to make that a required field or anything. There are other products listed in the table that don't have anything chosen in the reason column and thus they don't show up in the query. Ultimately, my form and in turn the report isn't showing information that it should. Any ideas on where else I should be looking? Kind of at a loss right now as to what I'm missing.

[pbaldy]

Edit the join between the main table and the "reasons" table. The correct choice should be obvious. In SQL view, it would change INNER to LEFT or RIGHT as appropriate to their placement.

[Waterdog]

Got it. Think I've got it working correctly now. Thanks for the suggestion!

[pbaldy]

No problem. Live long and prosper.