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