Sorry about this stupid question ...

When specifying a one-to-many relation I wonder how I can reference a column name in the parent to a coulmn name in the child which do not have the same name.

(NAME is the column name in the Child Table which links to the column name PARENT_NAME in the Parent)

In my parent mapping I have:

<set name="values">
<key foreign-key="NAME"/>
<one-to-many class="com.xyz.Child"/>
</set>

A) what is the difference in using

<set name="children">
<key>
<column name="NAME" />
</key>
<one-to-many class="com.xyz.Child"/>
</set>

B) Do I just have to add a <many-to-one> block in the Child mapping file like
<many-to-one
name="parent"
class="com.xyzl.Parent"
>
<column name="PARENT_NAME" />
</many-to-one>

to get the relation between NAME in the Child and PARENT_NAME in the Parent to work ?

Thanx
B

To answer myslefe ... redaing the documentation the
<key column referres to the parent key to be used as fk

So maybe the anwser is to use in the pafrent mapping something like

<set name="values">
<key column="PARENT_NAME"/>
<key foreign-key="NAME"/>
<one-to-many class="com.xyz.Child"/>
</set>


?

I ment of course

<set name="values">
<key column="PARENT_NAME" foreign-key="NAME"/>
<one-to-many class="com.xyz.Child"/>
</set>

Im not sure if you can achieve what you want, i.e. join on a column in the parent table other than the primary key...I ran into the same problem, and don't think there's a solution...