>That means that every time I delete a record a PACK must follow? Why is SET DELETED ON not hiding the duplicate key ?
You just have to understand how your development envireonment behaves.
Perhaps if you changed your key to KEYFIELD+iif(deleted(),"Y","N") if you really wanted to do this.
Or recycle your deleted records by giving them some sort of deleted key record number that was unique
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.