Multiple One-To-Many Relationships, Report Display

[Guest]

Greetings,

I have a client tracking database that has a main table, tblClient.

The table, tblClient, is the parent in several one-to-many relationships.
The child tables are tblClientReports, tblClientServices, and
tblClientContacts.

I would like to create a Client Summay Report that shows the Client Name one
time and then displays all contacts, then all reports, then all services in
groups underneath.

I currently have one query that pulls all information from all tables and am
trying to lay that out on a report in a way that looks attractive.
Unfortunately, I'm not having much luck.

Would I be better off using multiple queries or are there grouping/repeating
tricks that I am not privvy too. I've got years of experience with other
report development tools but this is the first time I've attemepted to do a
report of this complexity in Access.

Any help is appreciated.

Regards,
Bryan

 

[Duane Hookom]

Each "related" table should be reported as a separate subreport. This is set
up just like you would set up subforms.

 

[Marshall Barton]

Greetings,

I have a client tracking database that has a main table, tblClient.

The table, tblClient, is the parent in several one-to-many relationships.
The child tables are tblClientReports, tblClientServices, and
tblClientContacts.

I would like to create a Client Summay Report that shows the Client Name one
time and then displays all contacts, then all reports, then all services in
groups underneath.

I currently have one query that pulls all information from all tables and am
trying to lay that out on a report in a way that looks attractive.
Unfortunately, I'm not having much luck.

Would I be better off using multiple queries or are there grouping/repeating
tricks that I am not privvy too. I've got years of experience with other
report development tools but this is the first time I've attemepted to do a
report of this complexity in Access.

I think your best bet is to use subreports for the child
tables. The main report and the subreports would each be
based on its own table with the subreport controls having
their Link Master property set to the customer table's
primary key field. The Link Child properties would be set
to the child table's foreign key field.

 

[Guest]

Thanks folks. I had no ideas there were such things as subreports in Access.

In a former life I was an Oralce reports developer and we used repeating
frames.

A co-worker also mentioned subreports to me last night.

I'm going to give that a try this morning.

I appreciate your feedback.

Regards,
Bryan