Hi yes all the relationships were set up correctly, i managed to find a work around.
It worked if i put in a subform rather then a subreport, i know this is stupid really but yeah, it works now with the Subform, so ive just formatted my form to look like a report!!
Thanks for you feedback...
I just finished creating photos in reports and this is how i done it.
Basically i had a field in a table that contains the path to the picture eg C:\Pictures\Student1.jpg. I named this field "picturepath"
In your report have this field hidden so it cannot be seen (Change Visibility)
Then...
Erm I'l try my best to explain what im trying to do. I have reasonable experience with Access but not so much with VBA so i suppose in that sence im a n00b.
Basically I am trying to create a database that has details of a client in. But this client will have a non-predifined number of credits...