Create a one to many report - One record with subreport

[Guest]

I work in a school and need to create a FAMILY directory. I would like to
print one record for each FAMILY# with a subreport that lists each child in
that family, their grade & teacher. I already have a one to many database
FAMILY and STUDENTS linked by FAMILY#.

I added the field FAMILY.FAMILY NAME and a subreport for STUDENTS. However,
if there are multiple children, the report duplicates all the information.

Thanks for your help.

 

[Duane Hookom]

I think you only need to remove the STUDENTS table from the main report
record source.

 

[John Spencer]

Assumption:
Each student record has a Family Number in it.

The main report should be based on just the FAMILY table (no reference to
students)
The subreport should be based on just the Students table.
The main repot and sub report should be linked by the FamilyNumber.

 

[Guest]

THANK YOU! -- THANK YOU! -- THANK YOU!

Assumption:
Each student record has a Family Number in it.

The main report should be based on just the FAMILY table (no reference to
students)
The subreport should be based on just the Students table.
The main repot and sub report should be linked by the FamilyNumber.