I have a form that only allows a subset of choices for some of the fields, so I'm using a SQLFORM Factory and the IS_IN_DB validator to generate a list of allowable values for the drop down list. The determination of allowable values requires a join, which generates some duplicates in the drop down list.
Is there a flag or some other way to prevent these duplicates?? e.g., if it were a query, one could use distinct=True, however, here the parameter is a db. Thanks, Audra
