Hi All,
I have 2 tables, EF and EFD.
EF table has columns, ID, Definition, DefinitionName and Misc1.
EFD has columns, ID, Program, JobNum, Misc1Label.
Here, Definition is the foreign Key of EF table referring to ID in EFD table.
I want to access the values of EFD table.
<class name="EF">
<id name="ID" type="Int32">
<generator class="native" />
</id>
<many-to-one name="Definition" class="EFD"/>
</class>
I am trying to use Definition.Misc1Label, but it does'nt display anything. Please Help!

How do you look at the value ? Via debugger or via GUI (Web/Forms) ? There a few things you can try:

- check your database if there really is a record
- if the debugger shows the value as null , try and disable lazy loading on the many-to-one
- if the value is simply not shown in your GUI, have in mind, that you can't bind to something like "Definition.Misc1Label". DataBinding (at least Windows Forms) does not walk through the property tree
- if all that does not help, try to profile you DB session and check how the query looks like and what is returned.