Subreport generating too many returns

[DroolingIdiot]

I have a report pulling a recipe for a batch ticket. The recipe comes through a subreport which pulls all the materials associated with a formula, so:

Batch ticket defines formula in main report
Sub report defines recipe for formula

The problem is that the sub report brings back a complete formula for every line in the formula, so that if the formula has six items, I get six copies of the formula in the batch ticket (ie., main report.)

When run independently, the sub report only returns one line per material, and the query it's based on only returns one line per material, so there's something I'm not doing right (probably something simple) in calling the subreport from the main report.

Thanks in advance

 

[Crowley16]

how have you set the link child/parent fields on the subreport?

--------------------
Procrastinate Now!

 

[dhookom]

Do you have formula information in your main report?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[DroolingIdiot]

Yes parent/child relationships are set (FormNo to FormNo and BatchNo to BatchNo).

The FormNo exists in the main report, but there is no recipe in the main report.