Single Report from teveral tables with a single to many relationsh

  • Thread starter Thread starter Graham
  • Start date Start date
G

Graham

Novice builder so be gentle ;)

Here is the problem. I have constructed a report that utilizes a main table
that has a one to many with other tables. And example would be Customer
database, linked to tables of sales contacts and notes. Pluse other tables
that have multiple records.

When a I generate the report, the Customer information will repeat for each
record in the sales contacts, notes, and other tables. Therefore, though I
wish to generate a single report with all information, I have 30 reports for
a single individual. I know I could, in theory, get it to stop by
incorporating everything into a single table, however that isn't practical
given multiple entries, contatcts, etc.
 
Hello Graham,

Create a report/subreport. Base the main report on your customer table and
base the subreport on a query that includes the other tables. Depending on
what data you have in the other tables, you may need multiple subreports.
For each subreport, be sure to set the Linkmaster and Linkchild propertoes
to CustomerID.

Steve
(e-mail address removed)
 
Back
Top