>Hi All,
>
>When designing a table I create a primary key. Afterwards I design a form to input data to the table indexed by the primary key. When adding a record to the table and deleting it; I cannot reuse the same key because VFP´s error handling engine submits the message "unique key violation". My DELETED setting is ON. Why does this happen and how can I work around the problem.
>
>Thanks
By definition, a primary key is unique for each record. Because the deleted record is still in the table, it is not unique. There should be no reason to reuse a PK. For more information, see the KB article on my web site.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer