Your question title has the answer in itself, if you wanted to select the DISTINCT content, use the SQL query:
SELECT DISTINCT LoanTerm, LoanRate From...
This would return distinct records, for more on how to use this, please read this:
ALL, DISTINCT, DISTINCTROW, TOP Predicates (Microsoft Access SQL) [Access 2007 Developer Reference][
^].
Secondly, reading your question second time,
Quote:
I will have repeat numbers everytime i change selected index
Makes me think that maybe the problem is that you are having multiple records in the dropdown itself. For that, I simply clear the previous items in the dropdown and load the new list in the dropdown. You can try clearing the data source and set it again, or change the
ItemsSource
value to set it again.