>>Jess, the "-" character can be added to any character field - same idea as multiplying a numeric field by (-1)
>
>ohh yea... concatenate "-" to the character field??
>
>Actually the idea is good only for one deletion, otherwise, two or above makes the difference.
True, which is why I prefer to use a unique ID which the user never touches. Then I just get a new one. If the user enters an Invoice #, you can for existing records and ignore deleted ones.