Yes. I could get the data I was after by using a join

Thanks Ramesh,

As you can see in the orginal message I was looking in the wrong direction.

I have been able to apply in theory multiple joins to get the data I...