Creating a report from four tables

[Guest]

I am trying to create a simple database with four tables -
Customer Details
Policy details
Mortgage details
Call history details

By creating a query and then by using the report wizard, I have been able to
figure out how to create a report using two tables - showing their customer
details once at the top and then listing all their entries from one other
table underneath eg. policies.

My problem is, I am trying to create a report which lists the results from
all four tables ie. lists the customer details once then showing all their
policies, then all their mortgages then all their call history. But when I
try to include more than two tables with the report wizard, it seems to miss
the step about "how do you want to view your data" and it ends up producing
all the customer details fields for each policy, each mortgage and each call.

Can anyone help me with any pointers? Thanks

I am new to this board and although I've worked with Access before, I'm new
to creating a database from scratch so I hope I've given enough info & worded
it correctly, thanks.

 

[Larry Linson]

Consider a main Report, for your Customer data, with three Subreports, one
each for Policy Details, Mortgage Details, and Call History Details. In each
case, use the Customer ID in the main and related tables as the
LinkMasterFields and LinkChildFields of the Subreport Control. You will, of
course, need to create Reports for each of the related Tables to embed in
the respective Subreports.

I doubt you'd want to Join each related Table to the Customer Table in a
Query, because that could get "messy" very quickly.

Larry Linson
Microsoft Access MVP