Thanks for the help, in the end all that was required was a join.

I will have a look at those articles anyway for future reference. Thanks.