>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?
You would have to add the NOT DELETED() filter to you primary key
- Brian
VFP6 SP5, VFP8 SP1, VFP 9 SP 1 and Win XP SP 3 (unless otherwise specified)
www.wulfsden.com