Hi Dan,
Thanks for the catch on the rollback....

I'm actually feeling a little foolish...I found my error.
I didn't have the product name field marked as updatable in the view designer.
I think I'll go bury my head in the sand for a while.

I looked straight at that thing I don't know how many times...oh well.

Thanks,
Rick
----------------
>
>Two things offhand strike me.
>Your tablupdate does not look right. The first parameter is to tell if you want to update allrows .T. or one row .F.
>
>Unrelated problem. You are'nt issuing a rollback.
>
>
>BEGIN TRANSACTION
> llSuccessfulUpdate = TableUpdate(.T.,.T., "vpOrderItemsSupplier" )
> IF llSuccessfulUpdate
> END TRANSACTION
> ELSE
> ROLLBACK
> ENDIF
>* END TRANSACTION
>
><\TEXT>