Duplicate Information Displayed

[osu]

I am trying to pull information from a SQL database that contains Customer
Information, Contract Information and Contract Options.

I have a form setup when a user selects a company, it then pulls up the
customer contact information and the contract options they have purcahsed.

When the form populates, it duplicates the customer_options listed. I know
the customer_options table for that customer_id does not contain duplicates.

1. Not sure why it is displaying duplicates
2. Any way to select distinct values

or any other suggestions. I have tried using different controls, looked
through the posts and referenced another web site and have not found a
solution.

Thanks in advance for your help and/or suggestions.

 

[Ben Walters]

Osu,
Sounds like the problem might be in the query your using to get the data out
of the DB, Although it might be simplistic have you tried putting a
"DISTINCT" select on your query?

Cheers
Ben Walters