how to find unique records

[bv2000]

i have a database of about 7000 records. Each record is made up of 2 fields - ID# and Date of Svc.

Here is my problem: I want to make a mailing list and i must isolate all duplicate ID#. How do I do that. If I use the ! symbol, i must manually delete all entries for an ID# and just leave one. That will take forever. I am sure there is a much easier way to do that. Any help would be very appreciated.

[bv2000]

In case anyone is interested, I solved the problem myself by exporting all the records into EXCEL and when asked, I grouped the records by the field that had multiple entries. EXCEL automatically kept only 1 unique entry and deleted all the duplicates. I then opened a new file in FM with the EXCEL data.

[barryfh]

Hi bv2000,

Yes, FileMaker can do the job without needing to involve Excel.

http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=3441&p_created=1115172718&p_sid=jXMVjrti&p_accessibility=0&p_lva=5401&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MTEyNiZwX3Byb2RzPTAmcF9jYXRzPSZwX3B2PSZwX2N2PSZwX3NlYXJjaF90eXBlPWFuc3dlcnMuc2VhcmNoX25sJnBfcGFnZT0xJnBfc2VhcmNoX3RleHQ9ZHVwbGljYXRlIHJlY29yZHM*&p_li=&p_topview=1

Edited February 5, 2007 by Guest