You may want to look at GUIDs for this sort of thing:
http://fox.wikis.com/wc.dll?Wiki~GUIDGenerationCode~VFP>Thank you. I want to be able to order this key by chronology, so do I understand that
>
SUBSTR(SYS(2015),2, 9)+TRANSFORM(_vfp.ProcessId)
>would yield unique id's created on different machines at the precise same moment?
>
>dg
>
>
>
>>Adding ProcessId to should make the key unique
>>
>>transform(_vfp.ProcessId)+SYS(2015)
>>
>>>I am creating a unique key with substr(SYS(2015),2, 9) as the value. Would it require that 2 users on 2 machines create the key at the same millisecond to get a duplicate, or even at the precise same moment would different machines render different values?
>>>
>>>Thanks.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up