Microsoft Access Problem - Duplication
Posted on 2002-04-12
I created a Microsoft Access database with two primary tables... [TABLE A Sponsors] and [TABLE B Athletes]. The tables have a "many to many" relationship...i.e. Each sponsor can have many athletes, and each athlete can have many sponsors. I use a junction table to associate the records. It works just fine. My problem is that I am using [MS Access Reports] to generate letters (Invoices) to the people in [TABLE A Sponsors]. Each letter also includes a list of that particular sponsor's athletes. I must have MS Access Reports produce ONLY ONE letter to each sponsor. No matter what I do, I get multiple letters produced for each sponsor (the same number as there are athletes associated with that sponsor). For example: if a sponsor has two athletes, MS Access reports produces two "Dear Sponsor" letters. How can I fix this?