Thanks for the help. That soultion seems to work great when they can only cancel the order before they leave the order entry screen. But since later in the system they can cancel an order, I am left with both order header and order line items that are deleted but show up in queries. For example in another form the deleted items get selected:

SELECT DISTINCT descode,destype FROM orditems INTO CURSOR desitems WHERE !EMPTY(descode) ORDER BY descode

I need a way to exclude the records form being selected by this select statement.

Any ideas?

Thanks,

Randy Wessels

Try to change your select with this if it works:

SELECT DISTINCT descode,destype FROM orditems INTO CURSOR desitems WHERE !EMPTY(descode) .and. DELETED() = .F. ORDER BY descode

or try to filter first records that are not mark for deletion...



Jojo R. dela Cuesta
Dalplus Technologies