> 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.
If you are just looking for fields that are exactly the same, the SQL with GroupBy and Having gives a lot of flexibility Also the Distinct Values in most recent versions has a count array as a second parameter, in prior versions will just give you the list of unique values Neil ********************************************************************** 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************