i m not sure what the problem is - your script looks OK, unless the [Items Production Method] field is not in table Items. In that case, you will need to join the [Items Production Method] field to Items before applying the Item filter.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
The [Items Production Method] is part of the Items table, but the problem is, when I filter out (at the item table level), it just removes those items, but keeps the overall transaction, if that transaction also contains an MTS item. What I need to do is remove those transactions that contain an MTO item, even if the transaction contains MTS items too.