Good Day,
I have three tables. Probsummary, screlate, CM3R

Probsummary contains records called Incidents
CM3R contains records called Changes
screlate contains the relationships between the Incidents and Changes.

I have been asked to create a report based on the number of incidents opened for a particular group.

An incident has the unique identifier of probsummary.number
A change has the unique identifier of cm3r.number

An incident can be an incident without a change.
An incident can be an incident related to another incident.
An incident can be an incident related to a change
An incident can be related to more than one change.

Some examples:

Incident 1 has no changes related to it. Therefore, there is no relationship in the screlate table.
Incident 2 has an incident related to it. Therefore, there is a relationship in the screlate table.
Incident 3 has one change related to it. Therefore, there is a relationship in the screlate table.
Incident 4 has 2 changes related to it. Therefore, there are more than 1 relationship in the screlate table.

I want to create a report that will query the probsummary table for all Incidents created in the past month. In this report, I want to be able to list the changes related to the incident. I was hoping to do this without replicating the incident twice.

Example:

Incident 4 is related to Change 4 and Change 5.

The way my report looks now is

Number             OpenDate            CloseDate               Change #

Incident 4         01/01/11              02/01/11                 Change4
Incident 4         01/01/11              02/01/11                 Change5
Incident1          03/05/11              04/05/11                
Incident2          03/05/10              06/11/10                 

My intention is to print out the report so it can look more like this:

Number           OpenDate            CloseDate    Change #  Additional Change

Incident 4       01/01/11              02/01/11      Change4   Change 5
Incident1        03/05/11              04/05/11                
Incident2        03/05/10              06/11/10   

There may also be some cases where an Incident can be related to more than 2 changes. I don't know how to accomplish this or if it can be done. Am I better off making a bunch of subreports?

Any help is appreciated!

Thanks!