>
>I would like to check the unique value for the second column with indexseek. When I am inserting a new record no problem, but when I am updating one record the indexseek validate against the current record too, and it says that the record already exists.
Have you tried a SELECT statement, and look at _tally to see if it finds records?
Steve Gibson