>I Create a Table with a field X that is a primary key.
>
>I Input a record with X=1
>Delete the record, set deleted is on
>
>When I Insert record with X=1 again, Foxpro show the error: Unique index violation.
>
>The initial solution of the problem is:
>- In the filter of the index input !deleted() but....
>
>
>Is the unique solution ?????
>
>
>Thank You,
>
>Mauricio Mesa.
Primary key covers all records: deleted and non-deleted.
Edward Pikman
Independent Consultant