I have question that somewhat follows this thread
I have an existing BAQ that does quite a bit and I am adding to it and what I need to do is join Job Prod table (existing in BAQ) to a new table (Job Mtl) BUT… I only want to return records that satisfy a condition in the Order Dtl table (is part of the BAQ), SalesCatID= (my thing).
If it does not satisfy this condition, I dont want any job material records
I understand that constructing the BAQ around the Order Details to only get data based on the that condition would work at a glance but remember I have a pretty substantial BAQ that I want to add Job Material info to ONLY if that condition is met (otherwise I get way too much data that I dont want)
This may be a sub query but I don’t understand how to set it up (the ICE documentation I have ready dont help me much on this topic)