How to check for duplicate values in a field

  • Thread starter Thread starter Surinder Kumar Arora ITS GM EAST MTNL Delhi
  • Start date Start date
S

Surinder Kumar Arora ITS GM EAST MTNL Delhi

dear sir,
I have a database for recording complaint of telephone numbers. Sometimes I
get two letters for a complaint . thereby resulting in registration of
duplicte complaints. I have a field with a name Telephone . If I simply
select the properties of this field as no duplictes . I will get an error
message. This will happen if I have field length of 8 and telephone number
with 8 digits.But I have field length as 30 and I register more than one
number of a party in that field.
I want that if any of the Tel number is repeated an error message should
come saying that Tel is registered at ID number so and so as I have prmary
key named ID how to do it .
regards,
arora
 
Are you saying that you sometimes put two telephone numbers into the 30
character field? Don't! Create two separate rows in the table.
 
Back
Top