This may not be very concise programming, but I'm a newb.  Here's my basic problem, the following programming uses a certain number of the beginning characters of an entered address field to check for possible duplicates in its own form as well as another form in the same database.  If possible duplicates are found, a warning is posted in another element.

This warning system seems to work very well for my "Friends and Listeners" form, but in "Sticker Requests", where this programming resides, it flags almost every new form as a possible duplicate.  It also seems that the forms that are flagged are just flagged because the first two digits are similar.

Any ideas why this would be?

if addressLength > 14
     then
     {
           alteredAddress = @Left(address0, 9) + ".."
     }
     else
     {
           if addressLength = 14 or addressLength = 13
           then
           {
                 alteredAddress = @Left(address0, 8) + ".."
           }
           else
           {      
                 if addressLength = 12 or addressLength = 11
                 then
                 {
                       alteredAddress = @Left(address0, 7) + ".."
                 }
                 else
                 {
                       if addressLength <= 10 and addressLength > 7
                       then
                       {
                             alteredAddress = @Left(address0, 6) + ".."
                       }
                       else
                       {
                             alteredAddress = address0
                       }
                 }
           }
     }
     If @Add then
     {
           dupAddress = @XLookup(@Filename, alteredAddress, "Friends and Listeners!address0", "address0")
           if dupAddress <> "" then
           {
                 if @Instr(Problems,"Possible duplicate address in Friends and Listeners") = 0 then
                 {
                       Problems = "Possible duplicate address in Friends and Listeners database;" + Problems
                 }
           }
           dupAddress = @XLookup(@Filename, alteredAddress, "Sticker Requests!address0", "address0")
           if dupAddress <> "" then
           {
                 if @Instr(Problems, "Possible duplicate address in Sticker Requests") = 0 then
                 {
                       Problems = "Possible duplicate address in Sticker Requests;" + Problems
                 }
           }
     }

OK thanks that helped me diagnose the problem...

I have entered this programming only in the Add Data Mode because I am importing all this information from an outside source and then running through it real fast to check for duplicates, etc.

What's happening is a flag will show up for a "duplicate" if I ever reenter the record, because the programming fires again and finds the exact same record that has already been entered (itself) and counts it as a duplicate.

I hope that isn't confusing, let me give a hypothetical scenario:

-I move through record 1, programming checks, no duplicates, move on to record 2.
-I move back to record 1 for some reason, programming checks record 2, no duplicates.
-When moving back from record 1 to record 2, programming checks, yes there is a duplicate (record 1 was already entered)
-Once I leave record 2 it will also be flagged as a duplicate because it also has already been entered.
-In this way, if I do any sort of normal activity between records when adding them, most records will be "duplicates"

Any ideas?

Thanks!  Good idea!

Hello Nate,

I am not aware of any change in 2.0.5 that would affect this code. If your parents want they can send the DB and DAT files to support@lantica.com and we'll have a look at them and see what is happening.

-Ray