This is a good solution. But my grid has seven columns. Only after he enters all seven fields he will get the error.
I want to trap it as soon as he moves to the second column.
The number of records in the table are low so I can afford to scan in memeory.


At 1/22/02 1:54:00 PM, you wrote:

>Hallo GK
>
>> Now I want to prevent user from entering duplicate records.
>What about using a unique index to prevent users from adding duplicate values ?
>
>HK
>
>
>
>GK schrieb:
>>
>> Hello,
>> There is a grid which is bound to a TIBO Dataset.
>> The user can add rows and enter data.
>> This is working fine.