Are you really forced to let the user specify the customer number?

If not you could assign that customer number yourself. That way you'd eliminate that problem you just had.

>Hi everybody,
>
>I'm sure most of you must have seen this error message before.
>
>This is the scenario I experienced.
>
>I have a customer master file(single table) in a DBC with a primary key(cust_no).
>When the user deletes a customer record it uses DELETE command. The PACK command is issued to clear the deleted records only when another monthly routine program is run at the end of each month. Cust_no is alphanumeric.
>
>Before PACKing the table if another user enters a new customer with a customer number that is already deleted, it gives me the following error message.
>
> Uniqueness of cust_no is violated.
>
>I have issued SET DELETED ON command before entering the new customer. But VFP seems to keep track of deleted primary keys also in the index file(CDX).
>
>Can anyone tell me how to tell VFP not to keep track of deleted keys, or any other work arround so that I can enter new customer codes disregarding the deleted keys.
>
>Your help is greatly appreciated.
>
>Don