Query returns double records

[achammar]

Hi all again,



So I have a main table with 6 other tables. The main table is the one side and is related to each of the other 6 tables which are the many side. I have a subform for each table in a main form tied to the main table, but I think that's irrelevant.

I created a query using the main table and one of the sub tables to to return all the records in the sub table that match a record in the main table. This query is the control source for a report. It works fine for the most part. But I want to get another value from a different sub table for the report. So if I add that second sub table to the query, the data in the field that was currently working that is returned is now listed twice in the report.

I hope that made sense. I tried setting the report to unique records only, and that works, but then it leaves every other line blank in the report.

Any one know what I'm doing wrong?

Thank you very much!

[June7]

Yes, that output would be expected with multiple many side tables included in query. Use report/subreports arrangement.

[achammar]

Thanks June7! That got me on the right path for me to get it to work!