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!