>>>>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?
>>>In addition to Sergey's reply there is a file in Downloads section here called DupCheck. The author notified, what he released a new version of it recently...
>>
>>I couldn't find download with such name.
>
>Check download ID 289
As Nadya indicated, I'm currently working on a new version of DupCheck(), and anticipate releasing it in or before February 2002. It's a complete rewrite, compiled in VFP 6 SP4, with more bulletproofing and a better user interface. It also is an example of using COM to separate the front end and back end, which makes it possible to write a new front end (in VB, for example) if one desires.