I have several related databases that work together to run a biomedical process. One of the databases is a list of individuals. Another db is a list of events. Data elements in events include a date and a category. My client needs to create montly letters, reports and labels for each of the individuals for whom there has been some activity in the past. I need to select a date range and category, and then print the letters, reports and labels for that group of individuals. The problem is that there may be hundreds of entries in the events table for a given individual in a month. I want only one copy of the report, one copy of the letter and one mailing label for each individual.

Getting the letters and reports to work was not too much of a trick. I use layouts where I put the entire document into the subsummary part. My problem is with labels. I can't use the subsummary trick with labels. I've built a conditional variable in the people table that set's itself to "yes:" when certain categories are met and tried to do the sort from within the people table. What happens is that the relationship looks only at the first record in a portal and doesn't eveluate all of them.

Does anyone have a clue?

Thanks in advance,

Dave

Just wondering why you can't do the sub-summary thing with the labels?

OK...it works now...I guess I was doing something out of order because the last time I tried, the columns print option in layout setup was grayed out.

Thanks for the assist.