After browsing around on the froum I have found lots of people having this problem but no clear example.

Suppose I have a Parent and Child in classic one-to-many and many-to-one relation. The relation is NOT using the same column name. So, how do I specify the one-to-many block in the parent mapping file and how the many-to-one in the child mapping file ?

Do I need to use propety-ref ?

Let's say the Parent's PARENT_ID maps to the childs CHILD_ID and visa versa.

B-)

I don't get your problem. Where do you get the impression that you need the same column name for a many-to-one? many-to-ones allways are between the id column in the parent and the child table column you specify in your mapping.

Sorry, I was not clear enough. Suppose there is a case where the id column is not the one to be used to link the parent to the child.

Example

Parent table:

PARENT_S (the primary key)
NAME
PARENT_ID

Child table:
CHILD_S (the primary key)
FATHER_ID
SIZE


the one-to-may shall now bee made via PARENT_ID to FATHER_ID

and the many-to-one the FATER_ID to PARENT_ID

HOW do I specify such a situation ?

Thanx
B-)

And in the example above the PARENT_S is used as "id" for the Parent table and the "CHILD_S" is used as "id" in teh child table.