Hi Frank

>yes, you can have nested transactions. So if you start a new one and roll it back, then it won't affect your existing transactions.

Okay.

>Just out of interest, why are you trying to do this within a transaction that is running already?

What, start another transaction? That was because you suggested it to me *vbg*. Or a SELECT on the Table Buffered Remote View? Well that is becuase I have to only allow as much qty. for the items being enetered, so I was hoping to do a SELECT and find out the qty. already entered.

Anyway I have acheived the same using Non-SQL command.

Thanks for your responses.