>>Bear in mind that the DELETED() status has nothing to do with the uniqueness of a candidate or primary index. In any incremental key situation, you have to search all your table whether or not the records have been deleted.
>
>
>PMFJI but in addition, even if you should check the deleted records, a simulataneous add by two users will also give the same behavior.
I agree. Tying this into an earlier thread about unique keys, I don't even try to use sequential numbers unless forced to. I like to use GUIDs as primary (unique) keys.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05