Hide Duplicates

[Guest]

I have a field in a table that has a Lookup with the following in the row
source:
SELECT tblSOPs.SOPID FROM tblSOPs ORDER BY tblSOPs.SOPID;

When it looks up this table, there are duplicates in my drop-down list - How
can I "hide" the duplicates in my drop-down list?

Thank you, Karen

 

[Douglas J Steele]

SELECT DISTINCT tblSOPs.SOPID FROM tblSOPs ORDER BY tblSOPs.SOPID;

 

[Guest]

Thank you soooo much - It works great!

SELECT DISTINCT tblSOPs.SOPID FROM tblSOPs ORDER BY tblSOPs.SOPID;