Yes - but I'm confused how you would handle such a thing after replication or transfer?
If you link tables with your "local" (int) ID then you're back in the same boat of non-unique keys when you move data around. If you're only going to use the UUIDs then why bother with the Ints? It seems like you've got the same problems you started with, to me. (But then again, I am a bear of very little brain.) Jim Davis > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Schreck, Tom > Sent: Wednesday, December 08, 2004 12:53 PM > To: [EMAIL PROTECTED] > Subject: RE: [CFCDev] GUIDs as Primary/Foreign Keys > > By a dual key scenario, I am envisioning two different fields: 1 would be > the GUID and the second would be the sequential integer identity. ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED]
