>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
probably because until you pack the table that key still exists in the table.
Bruce Strom
Prayer of St Ephrem:
O Lord and Master of My Life,
Take from me the spirit of sloth, meddling, ambition and vain talk.
But give me a spirit of prudence, humility, patience and love.
Yes Lord and King grant me to see my own sins and faults
and not judge my brother.
For You are Blessed Forever and Ever. Amen.