I think in your situation it will only show the first related record. You may try putting a portal on the Parent record showing the child records. Looking at your screenshot, there seems to be a lot of duplication of inspections and units.
If you could explain a little more of what your database does, or should do, more help could be provided. For example, what is an inspection, an inspection of? The Company or of a Unit?
I'm sorry. It was a "Rookie" mistake. I had the wrong Table Occurrence in my when referencing the _fk Unit key.
It's shocking how many hours can be wasted on something like that.
Oh I know...part of the fun right?