>Bob:
>
>I tried to find the KB article without success.
>
>This was a couple of years ago and the problem was with VFP 3.0. I recall that if you INDEX ON a datetime field and you have two records that were the exact same date and time it was possible to view an additional record in a BROWSE window. The problem would appear after you APPENDed new records.
>
>I don't know if this was fixed in VFP 5.0/6.0, but I always use TTOC on any datetime field.
>
>Regards,
>
>--Paul
>
>>> ... In addition, I recall from a MS KB article that if you index on a datetime field it is possible to get duplicate records. The work around was to use TTOC to index datetime fields.
>>
>>I can't seem to find this reference in the Microsoft Knowledge Base. Can you help.
>>
>>Bob

"A word to the wise" as they say.

Thanks for the info.