one-to-many Print problem

[Pietro]

Hi,

I've a table "Company" that contains information about companies
:"Companyname,CompanyID,Address...", another table that contains information
about the responsible persons of these companies and their
contacts:"Tel,E-mail,....etc."
I created a relationship one-to-many between the two tables to gather them
in one query.
My problem is that when i print a report that's based on this query the
company that contains more than one responsible appears more than one time
(three times or four, depends on the number of the responsible persons)
So actually it looks very bad, is there a solution for this problem?

 

[TedMi]

Subreports were designed to address this very situation. Put the company
info in the main report driven by a query on the company table only, the
person info in a subreport driven by a query on person table only. In the
data properties of the subreport, specify CompanyID as the linking field.
-TedMi

 

[Mrs. Ugh]

Or just add a grouping level. Group on CompanyID and move all of the Company
info to the CompanyID Header. Then the Company info will show once and the
associated personnel will all be listed below.
Jill