I would have a primary index based on a guid (just my personal preference) and a separate field that is stored behind the scenes when the record is added (not on every save) that stores the datetime. You can use the tag to sort then later.


>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