Maybe a good reason to go to VFP 6 then, Wim, since it will execute there.

Good luck,

Jim N

>This Will not execute (syntax error). Tried it allready.
>Thnx anyway...
>
>
>>Try ALTER TABLE TableName ADD PRIMARY KEY uPrimaryKeyExpression TAG PrimaryKeyTag FOR NOT Deleted()
>>
>>HTH
>>
>>>Is it possible to do something like alter table or so, to create a primary index With a filter clause???
>>>
>>>I know this can be done with candidate indexes, but I don't know how to switch a candidate to primary.
>>>
>>>The filter clause is : !deleted()