Joe,

As you have been told, a filtered primary index (or any filtered index for that matter) will *not* be used by Rushmore.

BUT. . . there is nothing stopping you from having a second index exactly like your primary index but *without* the filter. Once you do so Rushmore is FULLY OPERATIONAL once again.

Cheers,

jimN

>>>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
>
>Yes... I see that would work but is that a good practice?