A one-to-many relationship exists between two tables in our database. A payer record is created in our Payer table that references the specific office in the office table of this application. When a user creates a payer record, there is a drop down based on the office table to select the office (from this other table with unique offices). In doing this for a quite a long time however, our payer records have multiple records with the same office name, but somewhere behind the scenes it represents a different "office". I have tried everything in my power to figure out where the duplication occurs. But if you report out by office, there will be as many as 3 different listings for the same office name (the name is exactly the same). None of the Payers are duplicated, just multiple office names for the payers that are all the same. Any help is appreciated.