it works perfectly, the only difference is firstly i used 'all' to try and retrieve a table defined through a relation and the one which worked i specified the exact id to find.
Thank you I have managed to solve it, since I am calling a 1- to- many relationship, it returns the whole result set, including the requested relationship table to access it i have to loop through the result set