Subforms and Reports

[flyboy66102]

I have two tables linked together. Table1 is my main table and table2 is my helper table. For example, I have an order form, the main form has all the customer information and is linked to table1. I have a subform with items and pricing, and is linked to table2.

In entering the data, and in viewing the forms, everthing works fine.

Now I am ready to create a printed order Report with all the information contained on the order form. If I try to create a query with both tables, I don't get any data. If I unlink the two tables or remove one, I get data. It seems the problem lies with the relationship some how, but I am unsure how to troubleshoot.

I need to figure out how to print a report with both sets of data.
Any advice would greatly be appreciated.
FB

 

[jrbarnett]

Check the relationship is set to use the correct type. I think it may be an outer join problem. Go into the query design that the report is based on and choose properties between the two and see what it is set as.

John