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).
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05