AnsweredAssumed Answered

Individual serial in multiuser solution-any faster way?

Question asked by shreedatye on Jun 15, 2017
Latest reply on Jun 18, 2017 by philmodjunk

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?