>hello all
>
>I have a grid based on a view and i get this error message when i updated a duplicate record,
>
>Warning The key defined by the keyfield property for table mydbc!table1 is not unique.
>
>Here is a sample data , key field is SSN
>
>Table1
>SSN
>123456789
>123456789
>987654321
>323552345
>
>Second record is a complete duplicate,so users selects it to delete.i just issue =tableupdate(.t.)
>
>but i get this error message.how to avoid this,any workarounds ???
>
>Txs for any help.

You need to use another key_field, which is unique and cannot be duplicated. Or add code to prevent adding records if they contain SSN already in the table.