Ha, well, that’s how I look for orphaned records. Possibly there is a better way.
But I mean if you weren’t implying this already
- Left-join JobAsmbl to JobHead
- Subquery criteria of Jobhead.JobNum IS NULL
And repeat as needed replacing JobAsmbl with JobMtl, then JobOper (maybe others?)
JobAsmbl is what got me before I think.
Like so:
