I have two tables with a one to many relationship linked by id.
How do i establish a forgien key relationship in the mapping file.

I am using Hibernate 1.

Thanks
Biswajit

Here is my attempt:

<?xml version="1.0"?>
<hibernate-mapping schema="XXCUSTOMER_CONTACT">
<class name="com.xchanging.customercontact.CustomerContact" table="customer_contact" order-by="order_ asc">
<id name="id" column="ID"/>
<property name="companyName" column="COMPANY_NAME" />
<property name="description" column="DESCRIPTION" />

<list role="contactInfo" table="XXCUSTOMER_CONTACT.customer_contact_info" order-by="order_ asc">

<composite-element class="com.xchanging.customercontact.CustomerContactInfo">
<property name="label" column="LABEL_" />
<property name="descritpion" column="DESCRIPTION" />
</composite-element>

</list>

</class>
</hibernate-mapping>