Jump to content

Filemaker's RecordID


This topic is 5740 days old. Please don't post here. Open a new topic instead.

Recommended Posts

It generates a unique RecordID for each table. But that doesn't mean it is safe to use in place of regular unique IDs because if data is imported/exported, the RecordIDs could be the same. They numerically jump by ever-increasing increments as the size of the table increases. :wink2:

Link to comment
Share on other sites

"... if data is imported/exported, the RecordIDs could be the same..."

I'm not sure that the recids suddenly become non-unique, I believe that the problem is the recids *change* when the nrecords are exported/deleted/imported (say when importing into a clone) which means relationships that relied on the recids will break.

Link to comment
Share on other sites

It depends on whether you import the records with the IDs or without. If you do import the original IDs, subsequent new records may auto-enter duplicates. If, during import, you auto-enter fresh ones instead, then your relationships will break.

Link to comment
Share on other sites

This topic is 5740 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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