Hi David,

Would the DISTINCT VALUES command help?
http://doc.4d.com/4Dv16R4/4D/16-R4/DISTINCT-VALUES.301-3317277.en.html

Best Regards,
-Tai B.




-----Original Message-----
From: 4D_Tech [mailto:[email protected]] On Behalf Of David Witton 
via 4D_Tech
Sent: Tuesday, October 31, 2017 1:41 PM
To: 4D iNug Technical
Cc: David Witton
Subject: identify duplicates

I'm looking for a strategy to identify duplicate records in a table - that is, 
records for which 3 fields are identical across two or more records - or in 
another case, where a single field is not unique.

Does anyone have a suggestion on how to proceed?

--
David Witton
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[email protected]
**********************************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[email protected]
**********************************************************************

Reply via email to