| Joined: Mon Sep 11, 2006 5:43 am
 Posts: 1
 | 
				
					| I have two tables that have many to many association between them. The tables are Product and Attribute. Many to many association is resolved using an associative table Product_Attribute. The table structure is as follows
 Product
 --------
 Product_ID (PK)
 Name
 
 Attribute
 ----------
 Attribute_ID (PK)
 Name
 
 Product_Attribute
 --------------------
 Product_Attribute_ID (PK)
 Product_ID (FK)
 Attribute_ID (FK)
 Date
 Value
 
 The associative table uses a surrogate key but also introduces a new columns like Date and Value. If these extra columns would not have been present than I could have map this relationship using idbag. If the associative table would not have introduced the surrogate key than I could have mapp the relationship using composite-element. Is there any way i can use idbag with composite element (or any other solution) to map the above mentioned relationships.
 _________________
 Regards,
 Khurram Rashid
 
 
 |  |