Federico,

Cool! I just cut this out for my tip book.

>Yes, you can: filter your primary key index on NOT DELETED(), and deleted records won't bother you. However, this has a drawback; since filtered indices won't be used by Rushmore, you will need to add a regular index on the same expression, so your queries can be optimised.
>>>
>>Uhhh! Are you sure about this? My experience is that a deleted record still will not permit a new record with the same primary key to be added to the table irrespective of SET DELETED status.
>
>Yep, it works. Cut and paste this program, and check it for yourself:

SET DELETED ON
>
>CREATE TABLE TryIt FREE ;
>	(MYKEY N(5), MYDATA C(20))
>	
>INDEX ON MYKEY TAG NOTFORUSE CANDIDATE FOR NOT DELETED()
>INDEX ON MYKEY TAG USETHISTAG
>
>INSERT INTO TryIt VALUES (22,"HI THERE")
>INSERT INTO TryIt VALUES (09,"ARE YOU WATCHING?")
>
>DELETE FOR MYKEY=22
>
>INSERT INTO TryIt VALUES (22, "HERE AGAIN")

>Good luck!