Script that loops through records and goes back to original record
I have a script that loops through all records to find duplicate entries. It basically shows all records and performs a loop looking for duplicates in specific fields. My issue is that once the script is done looping, it sends me back to the first record in the table and not the original one, and I can't find a way to get it to go back to that original record.
I have tried setting a variable with the current record ID before showing all records and using GoToRecord with a calculation that specifies the id field must be the same as that in the variable but apparently, this does nothing.
Is there any way I can achieve this with a script?