Basically I have following models in CakePHP:
User(id, username)
Photo(id, user_id, path)
I have set up following relation: User hasMany Photo.
On one screen, I would like to list users, and show random photo next to each user. I tried setting up following relation:
User hasOne SamplePhoto (where SamplePhoto is just Photo model)
but when user has two photos for instance, he is listed twice on the list.
basically my question is: can you reduce hasMany relation to hasOne, without adding any fields to table schema presented above? I would like to tell cake - find the first record in the Photo table which matches a certain user_id.