May 13, 200817 yr In past versions of FM, the issue of uniqueness of the record ID was raised and several schemes were suggested for making a record ID match field other than FM's native Auto Enter Number. I use an auto enter calculation: Get(HostDateTime) & Get(UserName) & Right(Random, 12). There is a theoretical chance of 1 in roughly 1,000,000,000,000 in one second that a duplicate will be made. Since my scripts make a single record per user button click, this is not possible. (for fun, I tested a looping new record script and was able to make about 3 records per second.) With the new version of FM, is the ID number uniqueness issue irrelevant? Can I now just use the AutoEnter number feature without the long and bulky calculation above? Thanks OS
May 13, 200817 yr There has never been a problem with using auto-entered serial numbers unless you need to import or synchronize data in some way.
May 13, 200817 yr What issue are you talking about? Serial numbers auto-created ahve been unique for as long as they have been there. I might add that Record ID's are different than serial numbers. The Record ID is an internal FileMaker marker. Steven
Create an account or sign in to comment