My scenario is that I am creating a BAQ toshow the entire Order, when one of the lines meets a particular OrderDtl.ProdCode. How would I go about filtering a BAQ to show me orders that have a particular OrderDtl.ProdCode when the order will have multiple ProdCode?
For example, Order# XXX has 3 lines and 2 our of the 3 are for a prodcode of Chevy and one line that has a prodcode of Ford. I want to filter the BAQ to only show me orders that have a Ford Prodcode on the order and show me all 3 lines.
Hope that makes sense