>>>>#3 is always a solution. Use a GUID, use a WSID+sys(2015), roll your own, anything but. I haven't found any use for autoinc, because by the time it appeared, my newid.prg (and anybody else's as well) was bug free.
>>>
>>>We do have our key generator, autoinc was more an experiment, at least for me - it felt like getting something for free...
>>
>>... with the nagging hunch that it will be worth every penny :).
>
>Actually a lot less, when you think what duplicate keys can do to your data.
But there's a benefit - if you lose one of the keys, you can still get in using the duplicate ;).