2 Replies Latest reply on Aug 2, 2009 11:15 AM by felisberto

    how to Delete Duplicate Records in FileMaker Pro?

    felisberto

      Title

      how to Delete Duplicate Records in FileMaker Pro?

      Post

      i have one table CONTACTS and another ZIP code.how do i remove duplicate in ZIP code tabel(zip,street,city)?

        • 1. Re: how to Delete Duplicate Records in FileMaker Pro?
          gunnerstudio
            

           Hey felisberto.

           

          Thanks for your post.

           

           

          Can you spesify what do you mean by duplicate in Zip Code table.

           

          If you have two contacts that lives in the same city and zipcode, you will have duplicates. and if you remove these, you will also remove the Street, Zip or city for the spesific contact

           

          If you got duplicated users you can create a validation calucation. normally (first name&" "& Lastname& " "&dob) and set the value to unique.

          That mean that you can only register one user with the same first name + last name + date of birth. 

           

          If you want to remove duplicates in zip code. create a script, preform find in the field you want to find duplicates and insert operator "!"

           

          Hope that helps

           

           

          Kind Regards

          Gunner 

          • 2. Re: how to Delete Duplicate Records in FileMaker Pro?
            felisberto
              

            thank you for your valuable answer.i would like to preventing duplicates data entry without warning.the last record inserted get automaticaly deleted.it shouldn't have filemaker custom validation.thanks

             


            gunnerstudio wrote:

             Hey felisberto.

             

            Thanks for your post.

             

             

            Can you spesify what do you mean by duplicate in Zip Code table.

             

            If you have two contacts that lives in the same city and zipcode, you will have duplicates. and if you remove these, you will also remove the Street, Zip or city for the spesific contact

             

            If you got duplicated users you can create a validation calucation. normally (first name&" "& Lastname& " "&dob) and set the value to unique.

            That mean that you can only register one user with the same first name + last name + date of birth. 

             

            If you want to remove duplicates in zip code. create a script, preform find in the field you want to find duplicates and insert operator "!"

             

            Hope that helps

             

             

            Kind Regards

            Gunner