Individual reports from 4 tables in one-to-many relationship

H

Heart-of-Dixie

I have one table that has personal data on each person (name, ID number,
address, etc.). The other three tables, which also have the ID number,
contain annual registration information; there may be more than one record
for each person in each of the three tables. The personal data table is set
up in a one-to-many relationship with the 3 tables, using the ID number as
the connector.

How do I produce a separate report for each person showing information from
the personal data table and the person's annual registration information from
the other three tables?

As additional information, there will be no standard number of lines of
information for each person in the three tables.

THANK YOU!!!
 
Top