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