I’m struggling with a query/dashboard… It’s E9 so I cannot do sub queries.
We have several jobs where Op 20 is sub-contract. In Op 10 we cut material to length then send it out in Op 20 for machining.
We want to find all the jobs where Op 10 has not been started AND Op 20 is sub-contact.
I can do the above separately, but don’t know how to bind them together either in a query or the dashboard…
Can someone explain in general terms how this might be done?