>I want to remove any discontinued products that have no stock or any onorder. However since there are multiple children, I need to confirm that all of the children have no stock or products onorder. Only then will I remove a discontinued item.
>
>Hope this helps,
>
>TIA,
>Mike

Yes, I re-read your requirements already and posted another message. Check with a select statement first to make sure you're doing the right thing.