Multiple One-To-Many Relationships, Report Display

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Each "related" table should be reported as a separate subreport. This is set
up just like you would set up subforms.
 
Bryan said:
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.
Click to expand...


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.
 
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
 
Back
Top