10 Replies Latest reply on Jun 18, 2017 10:41 AM by philmodjunk

    Individual serial in multiuser solution-any faster way?

    shreedatye

      I have a multiuser solution in Filemaker 15. Each user needs his own serial number for records created by him.

      I have a self-relationship USER -gUserID:UserID.

      IndividualSerial is a number field which is filled via a script

      Set Field (IndividualSerial; Max(USER:IndividualSerial)+1.

      As the number of records in the file have increased considerably the creation of IndividualSerial is taking more and more time.

       

      Any suggestions for improving the speed?

       

      ShreeDatye