Oldsneekers Posted May 13, 2008 Posted May 13, 2008 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
Fitch Posted May 13, 2008 Posted May 13, 2008 There has never been a problem with using auto-entered serial numbers unless you need to import or synchronize data in some way.
Steven H. Blackwell Posted May 13, 2008 Posted May 13, 2008 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
Recommended Posts
This topic is 6097 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now