Hi, I have a problem with using of many-to-one.
I have a xml that describes a table like this:

<class name="ObjectModel.TableParent, ObjectModel" table="TableParent">
<id name="Id" type="Int32" column="Id"
access="field.pascalcase-m-underscore">
<generator class="identity" />
</id>
<version name="RowVersion" column="RowVersion" type="Int32" />
<bag name="assetscopedetails" inverse ="false" cascade="all">
<key column="IdParent" />
<one-to-many class="ObjectModel.TableChild,
ObjectModel" />
</bag>
<property name=....>
.
.
.
</class>

The problem is that I want make join not by id field of the Parent table but by another field, and I not know how make this.

Someone can help me?

Please provide the full mappings for both ObjectModel.TableParent and ObjectModel.TableChild. Alternately, provide the table structure for each.

-devon

<?xml version="1.0" encoding="utf-8" ?>
<!-- Generated by ObjectMapper 14/04/2006 9.58.46. http://www.puzzleframework.com -->
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" schema="dbo">
<class name="ObjectModel.Auth.Permission, ObjectModel" table="Auth_Permission" mutable="false">
<id name="IdView" type="Guid" column="IdView" access="field.pascalcase-m-underscore">
<generator class="assigned" />
</id>
<property name="CanCreate" column="CanCreate" type="Boolean" />
<property name="CanDelete" column="CanDelete" type="Boolean" />
<property name="CanExecute" column="CanExecute" type="Boolean" />
<property name="CanRead" column="CanRead" type="Boolean" />
<property name="CanUpdate" column="CanUpdate" type="Boolean" />
<property name="Caption" column="Caption" type="String" />
<property name="IdAction" column="IdAction" type="Int32" />
<bag name="propertypermissions" inverse ="false" cascade="all">
<key column="IdAction" />
<one-to-many class="ObjectModel.Auth.PropertyPermission, ObjectModel" />
</bag>
</class>

<class name="ObjectModel.Auth.PropertyPermission, ObjectModel" table="Auth_PropertyPermission" mutable="false">
<id name="IdView" type="Guid" column="IdView" access="field.pascalcase-m-underscore">
<generator class="assigned" />
</id>
<property name="IsAllowed" column="IsAllowed" type="Boolean" />
<property name="PropertyName" column="PropertyName" type="String" />
<property name="Label" column="Label" type="String" />
<property name="ClassPropertyName" column="ClassPropertyName" type="String" />
<property name="IdAction" column="IdAction" type="Int32" />
<property name="IdProperty" column="IdProperty" type="Int32" />
</class>
</hibernate-mapping>

ParentTable is Auth_Permission
ChildTable is Auth_PropertyPermission