Error message for an indexed field on the Form

[sg2808]

Hi,

In my form (with multiple tabs), I have a field which is indexed and does not allow duplicate data. While checking the form I found the following problem:

I entered a value in the field which already exist in the database. I then tried to save it but the database correctly warned to say that same data exists in the database.

I then tried to navigate away from the Form by deleting the value I entered in this field but it is not allowing me to and is giving out a message:

"The changes you requested to the table were not successful because they would create duplicate values..........." I am attaching the screen shot of the same.

I had to "kill" the form and had to reopen navigate through the form.

My question is that why cannot I move away from the current tab in the Form to another tab even after deleting the duplicate data in the indexed field? As mentioned, I do not want user to insert duplicate data for this particular field.

What should I do so that I can naviagate through the form without "killing" the form? What should I do to avoid this message? "Killing" means closing the form using the "Close" X button of the form.


Please help.

Thanks,
SG

[sg2808]

I think I got the solution.. which is hitting the Escape key ones / twice.

[sg2808]

Correction - *once.

......................................