Distinct List in Drop Down Box

[devinst]

I am using the "Database-Driven Selection" options in a drop down box but would like to limit my options to a distict list of values in the field. Can this be done or will I have to revert back to creating the list into a choices and coice values bounded fields?

[Brian]

You can use the "Choices Selection Criteria" to narrow the options. This property is equivalent to a SQL "where" clause.

If the selection you need is too complex for that, you can either create an SQL view that gives the result you are looking for, or revert to using the bound choice fields.