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.