>>>Hi Andreas,
>>>
>>>The indexes are updated automatically, and normally work just fine. You probably have a corrupted index, because the record showed after you reindexed.
>>>
>>Hi Steve,
>>
>>I have already rebuilt all indexes of all tables every day. But the problem
>>appears about 8 times a day in different tables. Yesterday I ordered
>>Version 5.0a (currently 5.0). Maybe this will help.
>>
>>Andreas
>Hi Andreas.
>
>You did not mention if you were adding the recortd to a buffered table. If so, the cdx will not be updated until you do a tableupdate().
>
>Best Regards.
>
>Marcia
Hi Marcia,

I use optimistic table buffering and the index is not updated after the tableupdate().

In the meantime I have found out how to reproduce this behaviour. It seems to
be a bug in VFP5.0.

I have two forms like the ones of the form wizard and two tables. Add the
other table to the data environment of the form (vice versa) and make it ReadOnly.

Form1/table1 add to dataenv. table2
Form2/table2 add to dataenv. table1

Open the first form - change to edit mode - press undo (table revert).
Open the second form to update the table which is in the dataenv. of the first
form (readonly) without closing the first form.

Now none of the indexes is updated but the table itself is, when you add a record.

Workaround: never make a table Readonly in the dataenvironment

Andreas