good morning folks

seems to be an excellent community here, I'm hoping you can help me with an issue I'm meeting. I'm a fairly novice-y user so hopefully there is a straight forward ansewr to my question.

I'm writing a report where I'm listing all of the job operations on various sub-assemblies in a project. Some of the sub-assemblies may not have any operations but I still want to list them so for this I had to do a left join from the JobAsmbl table to the Job Oper table so my report looks like this

JobHead>JobAsmbl>JobOper
My report is grouped by sub assembly then so the output might look something like this

sub assy1
Milling 2hours
Grinding 1hour
Finishing 1hour

subAssy2


Subassy3
Milling 2hours
Grinding 1hour
Finishing 1hour


Sub assy 2 has no operations but I still want it displayed on the report. This would often happen when an engineer uses a subassembly solely to purchase parts and doesnt need any operations done (not the best of ways of doing things maybe)

I also want the report to list the materials required on each assembly so for this I created a subreport listing the materials and used a subreport link on the JobAsmbl table. This displays the relevant materials against the relevant assemblies then.

My problem is this, for any subassembly that does not have any job operations the sub report does not list any materials either.On any sub assembly that does have operations then the material subreport outputs fine.

I presume there is some problem with my linking somewhere along the way, I've been staring at this for quite a while now with nothing jumping out at me.

any help is appreciated.