>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.
Jocylyn,
So long as a record with a primary key is in the table, whether or not it is marked as deleted, you may not enter a new record with the same key. If you do you will get a "uniqueness violated" error.
Is there any reason you cannot recall the deleted record and reuse it?
regards,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.