Hi Jef Comments inline below...
> hi steve, thanks. > > the project is an annual competition for young composers. i receive an MS > Word doc containing individual scores and comments from each jury member for > all submissions. i convert the table to text, drop in excel and import to > JURIES from the excel file. the unique value in this case is an individual > score+comment by a juror for a specific piece. > > i need to be able to provide all jury comments (anonymously) to the composer. > > if we have a 20-member jury and 75 submissions, my layout (with the > sub-summaries layout part) is such that all 20 comments (1 per juror) fit on > one page, with the sliding/printing options set to remove all blank space. > therefore a total of 75 unique pages need to be printed (named > "ComposerLastName_ProjectName2010.pdf) and emailed to 75 composers > (participants). OK. I see. But I wouldn't do it like that, as I think you already understand. To split up your subsummary report by page into 75 separate emails would not be straightforward. So as I said, do it from AUDIO and set up the report without a subsummary – so it shows correctly when the found set is all the JURIES records for one AUDIO record. Then run the report from AUDIO by looping through the records; for each record find all the related JURIES records (I'd use 'go to related record [show only]' to do that) and make the pdf. > the composers and jurors are ubique records in CONTACTS (mailing address, > date of birth, bio, email etc.). in the relationships, Jury Members and > Composers tables are separate instances of the main CONTACTS database. > > so the structure within the database containing the comments was actually: > > JURIES___Jury Members table (CONTACTS) > \____ AUDIO___Composers table (CONTACTS) > > based on your comments, i started setting up the layout in AUDIO, and so far > got most of it working, except for some reason the same juror's name appears > for all 20 scores/comments... The most common reason for that is the wrong context; it's probable that the juror's name field is coming from a different relationship from the one you've used for the layout... > > AUDIO___Composers table (CONTACTS) > \____ JURIES___Jury Members table (CONTACTS) > > cheers, almost there!! > jef Yes, sounds like you are almost there... If you get stuck again, you might post the exact script you are using... Steve
