>Thanks Andy..I have already tried this. When it reaches "00000Z", it saves. When I ctrl Y, it gives me the error.

Hi Lisa.
Did by chance do this while creating the unique key?
INDEX ON UPPER(cid) TAG CID

As you no UPPER() will uppercase everything before evaluating. I just did here and it gave me the the unique key violation error.