| Beginner | 
				 
							
					  | 
				 
							 
				
					 Joined: Fri May 25, 2007 5:55 am Posts: 26				
			 | 
			
				
				
					| 
					
						 Hibernate version: 
 
 Actually using NHibernate 1.2.0 GA but asking the question here as it pertains to the mapping file as opposed to the underlying language. 
 
 I have a table of Portfolios. A Portfolio can contain many trades. However for various reasons I have to do this through two link tables. 
 
 Portfolio  1.... * PortfoliosTrades 1....1 TradeExternalMap 1...1 Trades
 
 I just want to go straight from Portfolion to Trades using the two Link tables PortfoliosTrades and TradeExternalMap. 
 
 We have a just reason for the database design which I wont go into now. 
 
 Can this be done. If so how. Any help much appreciated. 
 
 thanks,
 Richie. 
					
  
						
					 | 
				 
				 
			 |