1 Reply Latest reply on Nov 20, 2015 6:56 AM by Mike_Mitchell

    Duplicate entry notification

    KAtieNeal-Rizzo

      We use Filemaker for invoicing. We have a field in which we enter the PO#. Is there a way to create a pop-up notification if the PO# is being duplicated?

        • 1. Re: Duplicate entry notification
          Mike_Mitchell

          There are a couple of different ways.

           

          1) Set field validation to be unique. You can set a custom message if validation fails. In File > Manage > Database, click the field, click Options, Validation tab.

           

          dialog.png

           

          2) Set up a relationship between the table, and a copy of the table (another table occurrence) based on the PO #. Set a calculation such that Invoice::PO# <> InvoiceSelf::PO # as part of a Script Trigger. (I would probably use OnObjectModify.) If that happens, show the dialog.

           

          HTH

           

          Mike