I have a 1-m table relationship where an individual can have multiple designations. For instance, Joe Smith can be an ASA, FSA, MIID and DAS while Mary Jones is an ASA, FSA, and MPD. Each designation is part of a 1 to many relationship in a different table than the individuals name. I am trying to create a directory for each individual that lists all their designations. Currently, I am getting one record for each designation, so I have duplicate member names. Is there a way to get this information without creating a record for each designation instance?