Auto complete Filter

[kevin plummer]

Hi,

anyone know what filter expression I could use to just bring back "distinct" values?

In SQL I would use something like

SELECT DISTINCT BK_Unit FROM BOOK

but there is no "where" clause in the above to restrict the items returned that I can use in the filter.

Cheers,

Kevin