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

[aru]

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

[klaus]

Are you shure that you Adress column doesn't have the 'Unique' parameter set?

Otherwise it would be much easier for us to give you concrete advices if you post your code.

Best regards.

[aru]

Yes,

In My table there is only a primary key. it is the only first field.

[klaus]

Wouldn't you post your source code, so we could have a close look to find what you problem is ?

Best regards.

[derez]

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])