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