[AccessD] How to Question - check for duplicates in cascading comboboxes

Won't adding DISTINCT do the trick? Or is there more to the problem?

Susan H. 


Hello all


I have to ensure that there are no duplicates of species in this list unless
they have a different sub species. I figured the best way to do this will be
to check for a duplicate species and if there is one then check for
duplicate sub species, if there is then alert the user and set focus to this
duplicate.