>The unique key value is entered by the user (Eg. Account #).
>
>Thanx
>Gnana

Then you will have to do a validation before you do a tableupdate to make sure the value is unique. Do not allow the user to leave the field until it is unique.