>Hello,
>
>We are using Visual FoxPro 5.0 and we are making a framework. For our security form we have put an index with a primary key on the 'username' field. The problem is that if we delete a record using the delete-command the primary key still prevents us to make another record with the same username. Is there a way to exclude deleted records from the primary key? Thank you for your time.
>
>Greetings,
>
>Afier Appelman
>Using the account of Koos Veel

It's indication that primary key should be just sequential (surrogate) number having nothing to deal with deleted/non-deleted issues.