Error in search , Column Constrained to be unique, value 'already exist'

aru

Member
Hi,

I have a table of student. Which have lot of Fields. Around 15 fields Including Address, phone etc.

When I add record, then program is redirected to view Student details. Where we can search. Then I got search result.
Again I added student information. Then program is redirected to view student details. Then I again searched. Then I got an error
Column Address Constrained to be unique, value 'already exist' .
Actually table has only one Primary key. Address is not a key.

How can I debug this problem. I am expecting help and suggestion.

Thanks
Aru:sign0085:
 

derez

Expert
Licensed User
Longtime User
aru
"Unique" is a property of each column, not connected to primery key.
If you set your address column to be unique, you'll get this message if you input an address which already exist in this column.
Check this as Klaus suggested.

see the help: AddCol (Column Type, Column Name, Width [,Unique])
 
Top