Help with Report design

[Newposter]

I'm trying to design a problog report based on 3 tables. I have successfully designed a form based on these. The common field to all 3 is PartNo. The main table has PartNo, Description and Problem. Another table has PartNo, WhereUsed and Quantity. A third table has PartNo, Date and Status.

I can't set a one-to-many relationship based on PartNo, since this field may not be unique if future problems occur with the same part. However, the form displays two subforms based on the 2nd and 3rd table, and shows the info I need (i.e., weekly entries for status, so there are multiple status entries for each problem).

I can't seem to design a report that mimics the layout of the form. If I have multiple status entries and multiple WhereUsed, it replicates the entries from the first table, PartNo, Description and Problem. How do I create the report, or change my DataSource to reflect what I want?

Here's my DataSource:

SELECT [tblProblems].[PartNo], [tblProblems].[Description], [tblProblems].[Problem], [tblStatus].[Date], [tblStatus].[Status], [tblWhereUsed].[WhereUsed], [tblWhereUsed].[Usage] FROM (tblProblems INNER JOIN tblWhereUsed ON [tblProblems].[PartNo]=[tblWhereUsed].[PartNo]) INNER JOIN tblStatus ON [tblProblems].[PartNo]=[tblStatus].[PartNo]; Newposter
"Good judgment comes from experience. Experience comes from bad judgment."