Thanks for posting!
You can bring up all records with a duplicate id by doing a find for ! in your id field.
Yes, a find with ! followed by a sort to group the duplicate records so that you can easily see what values have been duplicated and how many times this has happened.
Here's a knowledge base article you may find useful: http://help.filemaker.com/app/answers/detail/a_id/3441/kw/duplicate
So I went through and ran the script from the knowledge base article (although I tailored to my sepcific database) but the script just ran endlessly. I know it started to work because I do have one x that showed up but then others. Here is the script I used. Please let me know if you see anything wrong.
Show all records
sort records [restore;no dialog]
go to record/request/page[next; exit after last]
replace field contents [no dialog;TESTREPORT2010::mark; " "]
set field [TESTREPORT2010::mark;"X"]
set field[TESTREPORT2010::Global;TESTREPORT2010::Trace log]
Is TESTREPORT2010::Global a field that has global storage enabled for it?
Yes it is.
Then it should work for you.
To take step by step look at what's happening during the script:
Enable the debugger and run the script if you have FileMaker Advanced.
If you don't, include a pause / resume inside the loop and place the global field on your layout so that you can see both the value of it and the value of the fields in the current record. You can also use Show custom dialog to pop up a window with selected fields so that you can watch the values change with each iteration of this script.