Jump to content

Recommended Posts

Posted

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

Posted

There has never been a problem with using auto-entered serial numbers unless you need to import or synchronize data in some way.

Posted

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.