duplicate values in dropdown:MOST URGENT

[paritosh123]

I am getting the error in a grid which has combobox.
This combobox allows only to select unique values from the list.
Whenever i selects the same value in another combo which is already selected in the grid, its shows the popup with the below message and makes us not to click anywhere else in the application.

"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship.Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries, and try again".


And when i delete the duplicate value selected in combobox it shows the popup with this message "Index or primary key cannot contain NULL value".

I simply wants this :
Whenever user selects duplicate value, message must be displayed and user comes out from that combo.

Please help urgently

 

[Taff07]

It sounds like the record is trying to save itself as you complete the combo boxes. You need to perform any checks your making without saving the record. This will aloow you to keep editing within the form.

Hope this helps.

Cheers

Taff