Need help with Script for finding duplicates

[Powersource]

Hello All,,,  I have a problem with my script.  This script identifies possible duplicates among members in our database.  For Example:  If when entering data if a member has the same last name and same zip code as another member then they are both identified as "possible duplicate" and then we can check to see whether they truly are the same member or not..    This will identify 2 or more.  There could be 5 members with the same last name in the same zip code.  Obviously if there is not a possible duplicate then we don't want the member to be identified as such:

 

 

My script works good most of the time but I have identified a problem and need help.  Here is the problem: Members all have record numbers.  In this example I will use numbers:  50195,  58862, 58899. With all members having the same last name and zip code.  If entering data for member 58862 it will correctly identify all 3 members as possible duplicates.  If entering data for member 58899 it will correctly identify all 3 members as possible duplicates.  ...  BUT when entering member 50195 it will NOT identify anybody in the group.  I have found this to be the case with all of the members when I run this script.  Whomever has the LOWEST record number does not correctly identify all others in the find as 'duplicates'.

 

Here is my script:

 

Set Variable [ $ZipCode; Value:ntanames2::Zip Code ]

Set Variable [ $Last; Value:ntanames2::Last ]

Set Variable [ $RecordNo; Value:ntanames2::RecNo ]

Enter Find Mode []

Set Field [ntanames2::Zip Code; $ZipCode ]

Set Filed [ntanames2::Last ; $Last ]

Perform Find []

If [ntanames2::RecNo = $RecordNo ]   (NOTE:  THIS IS REALLY "DOES NOT EQUAL" IN THE ACTUAL SCRIPT)

Replace Field Contents [ ntanames2::DUPE? ; Replace with caculation: "POSSIBLE DUPLICATE -ZIP" ] [ No Dialog ]

End If

 

 

All help is appreciated.  Thank you.

 

 

 

 

[MartieH]

i think you need to loop through the found set - checking to see if the recNo matches the variable for each one and setting the field for each one. if you don't do a loop, you are only performing your check on the first record of the found set - and if that record's number matches the variable, the script would stop. the first record of the found set should be the lowest record number.

 

Martie

[Kris M]

Easiest way to isolate duplicates is via a relationship. at least i think so...Check the attachment and see the relationship graph note

 

 

duplicates.zip

[Powersource]

i think you need to loop through the found set - checking to see if the recNo matches the variable for each one and setting the field for each one. if you don't do a loop, you are only performing your check on the first record of the found set - and if that record's number matches the variable, the script would stop. the first record of the found set should be the lowest record number.

 

Martie

 

Thank you Martie,  I will try this and let you know if this works.  I didn't think of looping thru the found set.  Not sure how to do this but I will read up on it.

 

Thank you,

 

Anthony