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
Criteria on Part table for isNull PartNum
Criteria on OrderDtl for OpeLine = 1
Results are listing parts in the part master