report / subreport help please

[Karen]

I am *trying* to make a subreport on a report and not getting the results I
expected.

The main table is tblreagent and the second table is tblingredients. In
tblingredients there can be many records with the same code in
tblingredients.fldcode. I have the tables connected in relationships using
a one-to-many relationship. The tables are related by fldcode (the same
name in both tables).

I have used these two tables on forms with no problems but when I add the
subreport for the ingredients list, the subreport prints on the report as
many times as there are ingredients for the code I asked for. The control
source for the main report is a query that prompts for an entry for fldcode.

What on earth (or anywhere else for that matter) have I done wrong?

Karen

 

[Karen]

Never mind!

I had the ingredients table in the query. Once I took it out of there,
everything ran as expected.

again, I jumped the gun on that one.

Thanks anyway,
Karey