DUDE!!!!

>>To continue the bank metaphor, what happens when the two banks merge?

Swear to God!!!! I thought this exact thing when I posted this....

Are you worried that we actually thought along the same lines....< bg >...


>>Somthing like an account number is fine as a candidate key - something an
>>end-user or a customer - say a bank customer who needs to refer to his/her bank
>>account number - needs to refer to. Yes, it is a unique number. However, as a
>>PK - to use something like an account number as a basis of a relationship
>>between database entities - is not correct.
>
>Exactly. To continue the bank metaphor, what happens when the two banks merge? That's when using GUIDs for primary keys starts looking awfully attractive....