AnsweredAssumed Answered

Question about Auto Enter Serial Number in a Filemaker Database

Question asked by tods on Feb 17, 2017
Latest reply on Feb 24, 2017 by PeterDoern

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,