AnsweredAssumed Answered

Finding set of unique records

Question asked by ncam on Oct 29, 2008
Latest reply on Dec 22, 2013 by jgalt


Finding set of unique records


Is there an easy way to find a set of unique records (no duplicates) as you can in MySQL?


I've made Filemaker scripts before that flag duplicates and delete the extras , but was wondering if there was a function or script step similar to "DISTINCT" in MySQL that would return a set with just one each of all records, even if there are some duplicates.


This would give me more options and speed up some of the data merges I'm doing between Filemaker and MySQL. Sometimes I send data to MySQL, find a "DISTINCT" set of records, and bring them back just to avoid setting up a flag duplicates script.


Thanks for any info!