No strong opinions, I like guids because I am not dependent on a system table to provide information for my key, it is all procedure driven. Nice when you are working with disconnected datasets, such as in a web environment.
>>I think of a customer entered key, much as I would a first name. Good information, but not something you can rely on. Useful for searches, but not a guarentee to find what you are looking for. I use GUIDs for my pk's. Love them.
>
>GUIDs of course solve the problem of creating PKs for computers which are not always connected. I was thinking about the following alternative, but never actually tried it: assign each branch office a different number, and create PKs like:
bintoc(branchnum, 2) + bintoc(SerialNumber("TableName"))>
>... where SerialNumber() gets a sequential number from a special table.
>
>This would use 6 bytes, instead of the 16 used by the GUID. Any opinions?
Carole Shaw
Fred Hutchinson Cancer Research Center
Eagles may soar, but weasels don't get sucked into jet engines.