>...I have two composite fields as my one PUBLIC KEY, so if I delete
>a record, I want it to be reusable straight away in case a user wants to add
>a new record, but this cannot be accomplished if the deleted record
>is not permanenly removed from the table in question.

Mick,

Primary keys should be generated automatically by the system and be used only to relate tables together. They shouldn't be re-used and shouldn't be entered by the user. Some apps never even show the PKs to the users.

What kind of data ins in the two field and why would anyone want to reuse the key straight away?