>I thank all in advance for any help. I have been asked to provide a screen lookup, or browse window where the user would like to filter and show only the records where a specific field has duplicates. Is it possible to do in an SQL, or do I have to write a function to extract the duplicates first, then simply browse those?

Hi Carmen,
If you want only display duplicates than

SELECT * FROM mytable ;
  WHERE KeyField1 IN ( ;
    SELECT KeyField1 FROM mytable GROUP BY 1 HAVING COUNT(*) > 1 ) ;
  INTO CURSOR crsDups