I want to query for Orders that have no related Order Products -- I have queried for related lists before, but I still don't fully understand how, and I feel more puzzled at this since I'm not looking for certain fields on the related products, but rather, specifically looking for a lack of products. How might I go about this?
EDIT: If there is no clean, straight-forward way to query...I don't want to retroactively add a field. My issue is that, in production, there are orders without products, and a trigger is trying to activate it based off of an activation date, and these occasional orders that, for whatever reason, don't have products, are popping up this error.
So, what might my best option be to round up all these orders without products and give them products?