By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,763 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Error message for an indexed field on the Form

P: 91
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
Attached Files
File Type: doc Doc5.doc (194.5 KB, 119 views)
Apr 26 '12 #1
Share this Question
Share on Google+
2 Replies


P: 91
I think I got the solution.. which is hitting the Escape key ones / twice.
Apr 26 '12 #2

P: 91
Correction - *once.

......................................
Apr 26 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.