>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.
Some variation of SELECT DISTINCT ... INTO ARRAY ... should do the trick.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up