Use row and table buffering and then ther uniqueness of they key
will not be checked until the tableupdate is executed

Good Luck
Jon

>I've been putting off using databases with primary or candidate indexes and feel it's time to try them out.
>
>How do you get around the Uniqueness is Violated error? Is there anything more savvy than populating the unique code field with something like '####' and going out and looking for a duplicate? Seems to me there should be something better than allowing it to come up with the error for you, and I'm sure that many of you have figured something out!
>
>Thanx,
>JR