Mutliple contacts on the one report

[thevans]

Hi

I am working on an event Management solution that requires a report not to dissimilar to a Mail Merge only the it needs to display who fills each role in a narrative form.

How do I get multiple contacts out of the tables, I can get one role but none of the rest

The Tables are Events----------Contacts

The Event Form has the Event Roles displayed on a portal.

If anyone could help that would be fantastic

Paul

[mr_vodka]

What do you mean by narrative form? Do you need a list or a list with commas, what?

Owner: Jack

Reader: Susan

Buyer: Ray

Owner Jack, Reader Susan, Buyer Ray