Hi Hilmar

May I suggest you always spell out Rushmore? It would help people when they search for Rushmore to see your reply to this person. By replying to you, I spelled it out so this thread will appear during a future search.

>>Hi Hilmar,
>>
>>>I am no expert in CodeMine, but recycling records through a view seems very problematic, in general. I would suggest you forget about it, and PACK your tables once a month.<
>>
>>I don't think there is a way to easily recycle deleted records with the view in CodeMine. However, the problem I am having is not with table gloat due to deletions, but rather just the occasional duplicate PrimaryKey problem (even though its a Primary index key).
>>
>>Mel Cummings
>
>OK, I see.
>
>My first option would be to assign primary keys automatically (sequential numbers, or GUID, for example), separate from fields which the user uses.
>
>If this is not practical, a second option is to filter the index on the primary key, on NOT DELETED().
>
>In this case, you might require an additional, regular, filter on the same field, for R.Optimization.