Stop printing multiple primary recs

[Trudye]

I have mulitple children records that can print under the parent record. The parent record prints on the first page and the children info prints on the second page. The multiple children recs are causing the parent rec to print multiple times. Is there a relatively easy fix for this?

Thanks much
Trudye

 

[Steve101]

Trudye,

Whats happening in terms of the data is a normal consequence of joining tables; ie. the data on the "one" side of the join is repeated against the data on the "many" side.

When dealing with this situation in reporting, you have a number of options:

(a) Use the "Hide duplicates" property available for each bound control being printed. This is useful if all of the info is presented on the same line in tabular format.

(b) Use Grouping in your reports, and print the Parent info in the appropriate Group Header Section, and the child information in the Detail section of the report.

(c) You can also set up and use subreports, but I suspect that that might be an overkill in this situation.

Option b seems the most appropriate for you to use here,

Hope this helps,
Cheers
Steve