Linking reports and subreports

[smithcesar]

I am trying to print a list of Members for each Project. There is a many-to-many relationship, since there can be more than one member in a Project, and each Member can belong to more than one Project. I need to print a list of Projects, and all the Members that belong to each corresponding Project or Projects. I already created a third table with a primary key from each table, named Project_Member.
I was trying to make a subreport with report. The report iterates through the Projects, and the subreport through the Members of that particular Project. I'm not sure how to link the data, and make the query know which Project to choose from, in order to list the appropriate personnel. I can easily make a query (using the three tables) that lists the Members of a "specific Project", for example, list all members for the Access Project. But I don't know how to go from there.

Thanks for reading this, and I hope someone can help!!

 

[mbuell]

This is really old, and you've probably already solved it, but . . .

This should be easy if the subreport shows the members by project. If it does, then the report/subrpt parent/child relationship simply needs to be set to the project id field.


BR;


Mark
<O>
_|_