Hi,
I need some assistance here.
I need to retrieve Production Order which has component's issue method = 'M'.
Eg:
Production Order #50001 has 4 components.
Component A, issue method = 'M'
Component B, issue method = 'B'
Component C, issue method = 'B'
Component D, issue method = 'M'
Production Order #50002 has 2 components.
Component B, issue method = 'B'
Component C, issue method = 'B'
When I run the query, I want to display the Production #50001 componenets simply because in this Production Order, it contains components with issued method 'M'. However, Production #50002 will not be displayed because no components are with issued method = M.
Appreicate any help in advance.