Ross:
This is usually the result of an index problem. Try re-creating your indexes. 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.
HTH,
--Paul
>I have a grid attached to a simple table containing names and a datetime field for reservations.When I Set Filter to dbf.date=> startdate and dbf.date<= enddate, I get an extra record on row 2.
>This record cannot be edited or navigated. So where does it come from? I've moved the record pointer to top, refreshed the grid etc etc and can't get rid of the phantom record. It's not consistent either, meaning, it isn't always there. I'm not using a view or query or cursor, just a simple table. Any ideas?