Excessive data displaying in sub-report.

[khughes46]

Attachment 16496 I have a meeting minute’s report that needs to print some data from prior year meetings. There may be as many as 6 meetings in a year for any individual. I copied the current year report, keeping only the fields needed for historical reporting and the linking field. Because there may be multiple meetings there are also multiple records. I have a print switch to prevent duplicate reports from printing in the current year. However when I copy the current year data to a prior year table there are multiple meeting records for individuals. This is where the problem begins. If there is only one meeting record, all is fine. However when there are multiple meeting records, the sub-report concatenates the multiple meeting data into the sub-report (example attached, with redacted dated, the rest is fictional). How may I prevent this from happening? Any help will be appreciated.

[ranman256]

Make sure the table is keyed on the fields so you cant get duplicates...
If the table has these 2 keys
[personID] *
[meetingID] *

no person will ever get a duplicate meeting no matter how many times you add it.

[khughes46]

Worked like a charm. Thanks.