Now that I am venturing into the land of DDs, it is time for me to learn how to handle this.

So I have a cDBCJGrid that allows the user to maintain a list of codes. For argument sake let's say it is a COLOUR database (for you'se all livin' south of me, that is spelled COLORS) and COLOURS only has only three records:

RED
BLUE
GREEN

The user goes to add a new code and on a blank line types in RED and when saving Gets "Duplicate record not allowed in file"... But now the screen is stuck in a dreaded circle, What is the elegant way to handle this?

PS... Sometimes you can never get the prompt to stop and have to bomb out of the program, but sometimes you might be lucky enough to return to the Code Column where you have to decide to add something like YELLOW so that you can save the record and get out of the screen.