>Happy Holidays Everyone!
>
>I've noticed that although a record has been deleted,
>when you enter the item again, Foxpro still complains
>that the item already exists when item is primarily key.
>
>I was wondering if there is a way to allow the
>re-entry of a primary key item that has deleted.
>
>Thank you.
What others have said is correct. If you want more information on primary keys and how to create surrogate keys, I have an article on my web site that explains that. The link is in my signiture.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer