I’m confused by my results. All I’m trying to do is raise an exception when a user closes a shipment with more than one order. However, the “number of rows > 1” in my query in my condition is true even when I only have a single order on the shipment. Am I missing something in the query itself? My p…

Here’s the Query you need in your condition: [image] Table Relationship between 1 & 2 [image] Table Relationship between 2 & 3 [image] Table criteria for table 3 [image] That should find rows where SHipDtl’s have the same PackNum (same as the ShipHead), but different OrderNums

DataDirective - "If more than 1"

Epicor ERP 10

Aaron_Moreng (Aaron Moreng) November 7, 2019, 8:38pm 14

grumble grumble grumble be careful about joining tt tables in a BPM query

1 Like