I'm setting up a reporting module and I ran into the following problem. I have a SELECT statement that selects records from several files, each record distinct. For example, one file contains names, another addresses, another phone numbers, and another clubs that they belong to. The SELECT statement creates a table using all of the files, so a person may be listed several times if they belong to several clubs or have multiple phone numbers. The user can then choose which fields they want to print on a report or label. The problem arises when they choose only fields such as name and address. I don't want to print multiple labels with the same name and address. Even though the records in the table are distinct, the limited fields that were chosen to print are not. How can I get the label to print only one record if the chosen fields are duplicated?
Thanks for any help,