Jef

I don't really get what your needs are. Maybe you could explain a bit more precisely?

For example, what is a project? Is that a record in AUDIO?

Who are the participants in a project? Are they the related record(s) in CONTACTS?

It seems that you are wanting to generate one pdf for each AUDIO that shows all the comments. Basically, you have to do the printing from the JURIES table. But you'd 'start' (ie run the script) from the AUDIO table. Loop through each AUDIO record. For each one get a found set in JURIES of the related records. Generate the pdf. Return to the AUDIO table and go to the next record in the loop. That will generate one pdf per AUDIO (project?)

How you address the email depends on who the participants are...

Maybe that will set you on the right track?

Steve

On Sep 12, 2010, at 10:52 AM, CEC jef chippewa wrote:

> hi, wondering if anyone could let me know of a solution to generate and email PDFs to provide project participants with comments from all jury members relevant to the piece they submitted to the project. relationships are as follows:
> 
> JURIES (comments) -- AUDIO (composition) -- CONTACTS (composer / email)
> 
> everything works up to seeing the pages as i want them: project information in the header, CONTACTS::composer and AUDIO::composition info in a sub-summary layout part (sorted by CONTACTS::composer) and all juror comments in the body. the layout.
> 
> i know how to name individual PDFs using the fileName variable, but can't figure out how to make it work in this context, because of the sub-summaries.
> 
> other email scripts i use work because they are done from within CONTACTS, where each record is one person/email.  i thought of doing it from a new layout in JURIES defined to "Show records from CONTACTS", but then i need a portal to show the comments, and the portal doesn't seem to recognize the sliding/printing options to remove empty space.  (i have to define the text area large enough to accommodate the longest juror comments).
> 
> any solutions would be appreciated.  hoping to avoid printing / naming /emailing the comments pages manually.
> 
> cheers,
> jef