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?