Creating a report of a one-many relationship on one line

P

PeteC

Hi,

I need to create a report which shows (on one line) the entries in a
one-many relationship.

For example, I have the following tables;

Customer
-------------
custid (*)
custname
custaddress

CustomerContact
-------------------------
custcontid (*)
custid (FK)
ccdate
encid (FK)

Enclosures
---------------
encid (*)
encdescription

EnclosureLine
--------------------
enclineid (*)
encid (FK)
enclineitemdescription
enclineitemqty

So, any customer can have a number of contacts with the company. The result
of any contact will be one enclosure (e.g. 'Enclosure Pack 1') being sent
out, which will consist of several enclosure items (e.g, Sample 1, Brochure,
Business Nameplate) - the list of items can be made up into any of the
enclosure packs.

I want to create a report which builds a letter for each contact, with a
line at the end giving (on one or more lines) a list of all the
enclineitemdescription included in the particular enclosure the customer has
been sent, e.g. Enclosures: 10 x Sample 1, 25 x Brochure, 1 x Business
Nameplate.

I can do this with a subreport if I want the enclineitemdescriptions on one
line each, but how do I get them all on the same line?

Thanks in advance.


Pete.
Derby.
 
Top