>I ran into a particular problem that I have trying to figure it out.
>
>I have a table with a primary index.
>I can add to the table. If I delete the record and cannot add another record.
>I get the Error Index Uniqueness. If I pack the table. I can add the record.
>Then I start the process again.
>
>I have set delete on -- does not work in this problem.
>
>What I ended up doing was to add to the filter option of the index
>tag the expression !DELETED().
>
>This allowed me to by passed my problem
>
>However, I have a question.
>
> Is this approach correct or is there a better way?
>
>Manny
As Larry said, you should not reuse primary keys. There is a KB article on my web site that discusses this and provides code to generate new PKs.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer