How to create a BAQ that provides Parents jobs and child jobs

Goal is to get a list of all jobs related to sales order, since MRP does not populated project ID to child jobs via make direct flag, i need to pull out a report for all children jobs and DMT in the project ID.

If you guys have a BAQ or a way to link child jobs with project ID.


For Production jobs, the linking sequence goes OrderRel > JobProd. Any Make Direct sales order release will link to its job via this path.

For Project jobs (jobs created directly from within Project Entry), there is a Project ID field in the JobHead table.