>Is there a way to load items from a table into an array but limit the loading to only records that have a unique value in a field? I have a contract database with many of the contracts having the same name. I want to have a dropdown list in a combobox associated with an array to select a contract name but not show duplicates. I know I can write many lines of code to do this, but for years now, I have wondered if there was an easier way. Thanks for the help!

SELECT DISTINCT ContactName FROM Contacts ;
  ORDER BY 1
  INTO ARRAY aContacts