2 Replies Latest reply on Jun 1, 2017 5:05 AM by MikeWile

    Unique values question

    MikeWile

      I inherited a solution where one field should have been set up to a unique value. Right now there are over 400 duplicate values in this field. I would like to change the field to validate as unique. Will this affect the records that have already been created?

        • 1. Re: Unique values question
          fmpdude

          No, but upon adding yet another duplicate, you would get a dialog like this:

           

          This isn't the kind of dialog a user should see or have to understand or decide how to proceed with, however.

           

          ---

           

          It's always a good idea to experiment with a play layout to see what happens first.

           

          ---

           

          Note that FMP using Find and "!" will find all the duplicates including the single value. So, if you're going to write a script, be careful how you delete duplicate entries. There's no undo for a delete in FMP that I'm aware of (other than a backup...).

          1 of 1 people found this helpful
          • 2. Re: Unique values question
            MikeWile

            Thanks. I wanted to fix it but was afraid it would damage the existing records.