select data for report

[Guest]

I have created a database of projects and resumes. the products table
includes a field for a small write up of the project. my resumes table
includes employee specific information such as name, education, job title,
etc. i would like to be able to select an employees personal information and
then choose the projects they have worked on from the projects form and send
all that to a report. i'm having trouble visualizing how i can format a
report to include an unknown number of projects. any help in this area would
be greatly appreciated. Thanks so much!
Katie

 

[Jeff L]

I believe what I would do is make a report for the employee and then do
a subreport for the projects he/she has worked on.

 

[Jeff L]

I believe what I would do is make a report for the employee and then do
a subreport for the projects he/she has worked on.

 

[rueskov_palle]

Katie skrev:

I have created a database of projects and resumes. the products table
includes a field for a small write up of the project. my resumes table
includes employee specific information such as name, education, job title,
etc. i would like to be able to select an employees personal information and
then choose the projects they have worked on from the projects form and send
all that to a report. i'm having trouble visualizing how i can format a
report to include an unknown number of projects. any help in this area would
be greatly appreciated. Thanks so much!
Katie

Normally I would have a third table to represent the *....* join
between Employee and Project.
It would only need to include EmployeeID and ProjectID and have the two
1..* relations set up.

Then make a simple Query that includes all three tables and take all
the Employee Fields and only the Resume field from the Projects table.

If you then use a Report guide on that Query it will suggest to make a
grouping on the EmployeeID, and that should do it. Then you only need
to design it a bit after.

Rueskov