spalmateer
Registered User.
- Local time
- Today, 13:21
- Joined
- Dec 5, 2000
- Messages
- 46
Hello,
I have a customer form with personal information (ie name, address, phone, ect.). I am trying to create a control that dosen't allow duplicate customer information to be entered. For example if an address is entered already in the customer table- then if someone enters the same address in the form a window pops up telling the user that that address has already been entered. Is there an easy way to accomplish this? I know that I could probably do this with composite keys but often we have a customer address with no name and vice versa. Currently my primary key is an autonumber cust number. Thanks in advance for the help and insight!
I have a customer form with personal information (ie name, address, phone, ect.). I am trying to create a control that dosen't allow duplicate customer information to be entered. For example if an address is entered already in the customer table- then if someone enters the same address in the form a window pops up telling the user that that address has already been entered. Is there an easy way to accomplish this? I know that I could probably do this with composite keys but often we have a customer address with no name and vice versa. Currently my primary key is an autonumber cust number. Thanks in advance for the help and insight!