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

Warning message on duplicate entry

P: 1
I have table name as MainT and Column name as CustomerNo. I want warning message on duplicate entry in CustomerNo. Please guide me easy way.
2 Weeks Ago #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,470
The easiest approach is to create an index on the [CustomerNo] Field which is specified as Unique. It may well be that you need a PK (Primary Key) which is an example of just such an index but without knowing more I can only suggest it as a possible solution. Certainly a Unique Index should do what you need though.

Best of luck.
2 Weeks Ago #2

Post your reply

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