>>>>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
Hi Andreas.

That is a new one on me. Glad you figured it out. Something for me to keep in mind when I go to version 6 (I'll probably skip 5 since I'm still stuck with 3.0b...should be out of the 16 bit business by the time they release Tahoe)

Best Regards.

Marcia