I have three tables with the following struture:

client [ client_id, ...]
licence [licence_id, client_id, ...]
photo [ photo_id, client_id, ...]

I want to have an association where the Client object contains the Photo object. it is a one-to-one association - though not enforced by the schema.

This scema has been implemented very akwardly - and (of course) cant be changed..

is there a way to map this ? Is it a one-to-one with a formula that performs the join ?

thanks for any help.
regards,
mark.

Sorry ...
i meant the Licence object should contain reference to it's Photo object.
Both are entitites.