I have a primary index (ordernum) on a table (orders).

If I delete record ordernum=1 then try to add a new
ordernum=1 I get a message stating that the uniqueness
of primary key ordernum is violated. Is there any way
to make the vfp5 ignore deleted records when adding a
new one with the same key?