Open lines with a "fake" part number BAQ help

I understand orders can be created with any part number we want that may not exist in the part master… I need to get a list of open orders with a “fake” part number. I created a query as it seems pretty simple but I can’t get the join to do what I want(results don’t make sense…), can someone point me in the right direction?

Join OrderDtl to Part table with a join type of All Rows from OrderDtl
image

Criteria on Part table for isNull PartNum
image

Criteria on OrderDtl for OpeLine = 1
image

Results are listing parts in the part master
image

Try doing the ISNULL as a subquery criteria and not a table criteria.

1 Like