You're right, Jim - don't use the INT as a foreign key. It's really just there as an alternate key to help lighten pages that might otherwise be made a lot heavier by GUIDs.
Going OT a little, where GUIDs also come in really handy is offline apps. For example, if you have a Palm app that lets the user create new objects, using GUIDs lets you define a new key on the Palm without worrying about sync errors later due to overlapping keys, and without having to do any massaging of the uploaded data to resolve those keys. So to keep on beating that horse, INTs do have their disadvantages, but they're good for keeping down page weight in web-based apps that display a lot of data. ---------------------------------------------------------- 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]
