>>>stocknum is fieldname in view intrancust
>>>
>>>GO BOTTOM
>>>IF empty('stocknum')
>>>DELETE in 'intrancust'
>
>So if something is marked for deletion it will not be included in a query?

Only if SET DELETED ON