Hi all, new to BAQs and dashboards. I have a BAQ listing job numbers, materials etc using jobMtl/JobAsmbl etc etc, I have placed a couple of buy to job Purchase orders for testing. I added PORel as that has both JobNum and PONum and linked them to JobMtl by the job number but it just displays the …

This is where the join types come into play. This in SQL terms is a “left join” even though they renamed it in BAQ land. But set it to “All rows from JobMtl” and now you should see all of the material lines with blanks for the PO information. [image] [image]