2 Replies Latest reply on Jul 25, 2012 5:36 PM by dennjon

    Is there a way to prohibit record duplication?

    dennjon

      Title

      Is there a way to prohibit record duplication?

      Post

      We're using FMP 11.04.  One of my data entry gals inadvertently duplicates a client record about 3 or 4 times a week (she hits Command-D instead of Command-F while searching).  Because of some lost records in the past, this same staff person is prohibited from deleting records; therefore, each time she accidentally creates a duplicate I have to delete it. Not a big deal, but what I'd love to see is a warning before duplication or a no-duplication setting.  Is there such a setting?

        • 1. Re: Is there a way to prohibit record duplication?
          philmodjunk

          IF you have FileMaker Advanced, you can give the data entry layouts a custom menu where duplicate record has been removed or just modified so that it no longer has a keyboard shortcut. I've removed the keyboard shortcut for deleting records from a few layouts for similar reasons. (So supervisory personnel can't accidentally delete a record via shortcut.)

          You can also provide a "delete" option that doesn't physically delete a record but instead sets a value in a field so that scripts, finds etc no longer pull it up on the usual data entry layouts, but it's still in the system. That allows an admin person to find and "undelete" the record on occaissions where this is needed. If getting a large number of "deleted" records in your table is a concern, you can set up a script that deletes them after they are specified number of days old such as 60 days after being marked "deleted".

          • 2. Re: Is there a way to prohibit record duplication?
            dennjon

            Thanks, Phil. That's exactly what I needed to know.