Hi
You can use the IndexSeek() function after getting a value from Sys(2015) to check if it is unique. If not just get another value.
One advatange of a system wide PK is that when several tables are used in a tree view you can use the PK as the node ID because it is unique across the database.
Simon
>Can anybody certify that the SYS(2015) function is generating unique ID. I plan to use this as a primary key in a big system and I want to be sure it won't generate duplicate...
Simon White
dCipher Computing