Hi
I have something like right(sys(2015),9) + Workstation Id (3 chars)
The local workstation id is generated once from a counter on server (integer) and saved locally in a configuration file.


>I want to create a unique record key that is based on timestamp. So when I sort the records on this key, they are sorted in datetime order.
>
>Any ideas how to create this unique key? Would like it to not be a date field, and to be as precise as possible, and as short in length as possible.
>
>Realize that I will have to check for duplicate key prior to inserting a new record as that two records quickly inserted might get a duplicate key.
>
>vfp 6.0.
>
>Thanks
>
>Brenda