Hi Oliver ---

If the entry can be duplicated by the user, it's a poor candidate for a primary key. You are going to have problems with this. Your best bet is to have a second field with a unique or sequential value assigned by a stored procedure -or- other methid/function. Then, you can accept the duplicate value and check it versus the rest of the database in the Grid's AfterRowColChange method and/or at Save time.

>How can I handle the dupliate record in the grid. The table has one field and index on this field (using primary index).