One Invoice Report for Each Record in a One to Many

[molsen]

Hi All

I have a report, based on two tables which I have combined into a query.

The first table is the invoice date & ref, and the second table is the invoice amounts & descriptions, which could be more than one.

I have based the report on the underlying query, and I want all the many invoice & amounts to appear on one invoice, but I get one invoice for each of the many sides of the relationship.

I have a related key field in each table, with a common ref and referential integrity and cascade update set, but it still produces one invoice rather than a combined. Any help would be appreciated!

Tks

Mark

 

[pr2-eugin]

Hello molsen, have you considered using SubReports?

 

[molsen]

Thanks Eugin - I should have thought of that!

Doh!

 

[pr2-eugin]

You are welcome.. Good Luck..