from my experience, primary key fields should never be used again once they have been deleted. i've done several systems where there are many fields that must be unique, but we do not use these to build a primary key because they are user entered. if/when we need a primary key, we use a system generated key that is internal (user never sees it) so that we don't need to worry about the problem you're having now.

>I need an advice. What shell I do in this situation.
>
>From the beginning I had one table with a primary key, but then
>I noticed that three fields where seldom used and because I don't
>have much disk-space I splitted the table into
>four tables. The parent table and three tables with two fields each
>(the primary-key from the parent table and one of the seldom used
>fields). In this situation my problem is when I delete a record
>in one of the three tables and after a while I want to insert a
>new record with the same primary-key. That is why I asked
>yesterday (How do I use RECALL) if this is a solutien to my problem
>
>SET DELETED OFF
>IF SEEK(...)
>RECALL
>UPDATE ...
>ELSE
>INSERT ...
>ENDIF
>SET DELETED ON