Hi

I have make a form and place my table in the data environment. When I try to execute a SQL statement "insert into tablename value ( ......)" in the code, it did insert the data in the table but also it replace the field (The one which is index on) of first record with the inserted value too ?

Example I insert a record with the following field

Product_code = XYZ123
Part_code = ABC111

the table has a new record with the above data but the first record product_code value also been replaced with "XYZ123"

How this can happen ? And how I can avoid this ?

Thank you and best regard