You can add integer Primary key to your table and populate it with sequential Id's.
>hello all
>
>I have a grid based on a view, which has duplicate records.so the users want to delete the duplicate records.but the original records also gets deleted.
>
>DBSETPROP("vueTable.ssn","FIELD","KEYFIELD",.T.)
>
>how can i make the record number and SSN field as the keyfield,so that when the users selects a particular record only that gets deleted.
>
>OR
>
>in simple terms how to delete duplicate records in view.
>
>txs
--sb--