Forigen key to Composit primary Key

[Purushotham Panduranga]

Hi All,

How can i create hbm mapping for a scenario of Forigen key to Composit primary Key. below is the problem defination.
I have 2 tables one table has 3 columns, all 3 columns are part of composit key. Another table has 2 columns and all the 2 columns are part of composit key.

ITEM_TABLE
USER_ID, DEPARTMENT, ITEM_TYPE

USER_ID, DEPARTMENT, ITEM_TYPE are composit keys.

USER_TABLE
USER_ID, DEPARTMENT

USER_ID, DEPARTMENT are composit keys.

How to create relation between ITEM_TABLE and USER_TABLE.
I am using Hibernate 3.1

Thanks
Purshi

[Rashid Darvesh]

This might be helpful but its implemented in JPA
http://www.makemyinfo.com/Tutorial.do?action=getTutorial&tutId=T0009.jsp
Rashid