need help with report

[valley8338]

I am designing a database to keep track of projects. One part of it I made a form that keeps track of who has the project. This table is project track. i have it liked to the project info table by the project ID (not the primary key, but it is an indexed field). This is a one to many relationship since the project goes back and forth between several people.

Anyways, now I want to make a report or query (I am not really sure, i keep trying either/both) that will print out where the project has been. I would prefer to be able to select the project and just have that info come out.

This is the format I am trying to get out (with what table the info comes from.

project name (projectinfo)
ProjectID(projecttrack/projectinfo)
Project Lead (project info)
Designer (projectinfo)
sendtoprinterby(projectinfo)

to (projecttrack)
date (projecttrack)
time (projecttrack)
initials (projecttrack)
comments (projecttrack)

Any help would be greatly appreciated. I have been working on this for so long, I am lucky I have hair left...

 

[RSi2]

you'll have to make a report with a sub-report linkled via the ID.
In the first you put :
project name (projectinfo)
ProjectID(projectinfo)
Project Lead (project info)
Designer (projectinfo)
sendtoprinterby(projectinfo)

And in the sub-report (detail)
ProjectID(projecttrack)
to (projecttrack)
date (projecttrack)
time (projecttrack)
initials (projecttrack)
comments (projecttrack)

Use the wizard ... it will ask you wich is the link between the reports ... => ProjectID