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

How to prevent duplicate value in one field checking it from two or more fields

P: 1
I have two fields Phone1 and Phone2 in my form. I want Phone1 after update to check its duplicate value in both phone1 and phone2.
Similarly Phone2 to check phone2's duplicate value in both phone1 and phone2 and find that record in database and show it to me.
Oct 28 '14 #1
Share this Question
Share on Google+
1 Reply


Seth Schrock
Expert 2.5K+
P: 2,941
This is why you normalize your database. It makes this problem disappear. See Database Normalization and Table Structures.

Are you wanting them to be checked in the whole database or just within the one record?
Oct 28 '14 #2

Post your reply

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