queries or tables?

[ejohns]

I have a db with multiple tables to manage different contacts.



Each contact has a general information entry in ContactGeneral and then more detailed information in other tables related to ContactGeneral.
For example, John Doe has a basic information record in ContactGeneral and then 2 records in ContactEmploymentHistory for his past two jobs as well as 2 records in ContactEducationHistory for his two degrees.

How would you suggest going about creating a report that showed all the information in the db on John Doe?
Would it be best to add all fields to the report from their respective tables and then group? Or to create a massive query with all the information and then create the report from the query?

Thanks.

[RuralGuy]

How about looking into SubReports?

[ejohns]

Never heard of SubReports...

[RuralGuy]

They work on Reports like SubForms work on Forms. Should be a good way to display the Many side of your 1:m relationships with each Contact.

[ejohns]

Thanks for the suggestion! They are definitely the solution I was looking for...

My only problem is that they are covering each other up in the report view...even though the property sheets are set to can grow/can shrink.

Some of the times they are working perfectly other times they are not...

[RuralGuy]

All of the sections have "can grow and can shrink" properties as well. They need to be set that same way.

[ejohns]

Everything is set to can shrink/can grow...

[RuralGuy]

Could it just be a video issue? How does the report print? Are you using the latest video driver?