11 Replies Latest reply on Feb 24, 2017 10:01 AM by PeterDoern

    Question about Auto Enter Serial Number in a Filemaker Database

    tods

      Is there a way to have Filemaker autoenter a serial number for a record ID, but if that record ID is in use, skip over that number and use the next available record id number?

       

      Basically I don't want to have to manually go in and change the 'next value' box in the Field Options to be one number higher than my last record.

       

      I tried checking 'unique value' under the Validation tab, but that requires manual input, and I would like something that is automatic.

       

      Thank you,

      Tod