AnsweredAssumed Answered

Summary list of related values

Question asked by PaulSmith on Oct 18, 2011
Latest reply on Oct 19, 2011 by philmodjunk

Title

Summary list of related values

Post

Hi there,

A curly one...

Customers   attend

Sessions

 

I need to export a list of badges showing

Customer name,  sessions summary

Where session summary is a comma delimited list of session codes that customer is attending

eg:

Alex David, CF2D

Peter Jones, WK1, CF2D, WKB, GD

Susan Amis, WKB, GD

 

Should I try to achieve this using a calculation field on the person record to summarise their events or is this database performance hell? If so is there a standard function I should use, or do I need to create a script?

or

Is there a way that I can make a report print left to right, or should I create a script? Similarly can someone give a general clue as to how I go about looping through related records in a script?

Many thanks

Paul

 

 

 

 

Outcomes