The Software Man Posted June 20, 2009 Posted June 20, 2009 So how unique is the recordID when importing and exporting data between similar files that originate on separate FMS 10 servers? If I use the calculated field: myRecordID = Get(CurrentRecordID) and use it as the matching field when importing with create, am I setting myself up for a big disaster? Or would it be wiser to use a compound index field using the date/time, user name, and some large random number? Hoping that the multiple servers (7 btw) would not create two duplicate numbers, ever, ever, ever, for millions of records? Or am I screwed either way? Maybe one is a more kind screwing?
comment Posted June 20, 2009 Posted June 20, 2009 Get (RecordID) is unique within a table - not even within a file, and certainly not across files. Why don't you use auto-entered serial numbers, with a unique prefix for each source?
Recommended Posts
This topic is 5986 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