It sounds like you're generally having problems with your index tags. That would explain replacing data in the wrong record. In a similar thread, I asked how you're creating your index tags because it doesn't sound like you're using structural CDX indexes. You should be using code like this to create your tags:

select SomeFile
Index on Field1 tag Field1
Index on Field2 tag Field2
etc.

That will create a structual CDX for you that is always opened with the table, and is always kept up-to-date.

Also, you should avoid using the REINDEX command because it won't fix your index properly if the header has gotten corrupted. It's better to DELETE TAG ALL and recreate the tags with the same code you used to create them in the first place.

>Hi all,
>
>I alway facing this problem whenever I execute a SQL insert statement to a table and later find the form cannot retrieve the data properly from the table example like some record field is blank but actually the data is still within. But if I quit the form and rerun again, it turn OK. Presently I using reindex to fix the problem but i also understand that this is not a good solution. I have been told that the index supposed to be automatically updated once we insert a record.
>
>Any 1 know what is really the problem and how can i fix this problem ?
>
>Thank you and best regard