>>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
Brian,
If you are bound and determined to reuse a deleted primary key then just RECALL it (which undeletes it) and condition the fields in the record to 'new' condition before displaying the entery screen.
JLK
Nebraska Dept of Revenue