<class name="AggDeal, Model" table="agg_deal">
<composite-id>
<key-property name="DealId" column="deal_id" type="Int32" />
<key-property name="PVDate" column="pv_date" type="DateTime" />
<key-property name="Ccy" column="ccy" type="string" />
<key-many-to-one name="Client" column="pty_no" class="BClient,Model"/>
</composite-id>
......


Is it possible to have a collection based on only the deal_id column of the above composite id.

Based on my attempts so far nhibernate appears to always require that the foreign key table has a foriegn key composed of the full set of columns in the referenced primary key.

or am i missing something?

Thanks,
Damon