Hi,

Let's say one has this scenario:

CustomerOrder - table for the customer's orders
OrderDetail - link table between the order and the products. Besides the keys from CustomerORder and Product, the table has another column "quantity"

Now, the Product table, has subproducts that can be selected by the customer. So we need a many2many table between OrderDetail and Subproducts.

Now, in CustomerOrder, the OrderDetail is mapped as a composite-element. In OrderDetail, there is a many-to-many mapping with Subproduct.


The problem is that when i save or load a CustomerOrder , the subproducts are just ignored.

I'm thinking that when I save the order, it only knows about stuff that is in the composite-element, and I can't put a bag in there.
[/img]

up

Really? Usually in this example, each OrderDetail points to one and only one (Sub)product. It is the association link between the order and the products on it, with a quantity.

An order detail contains a product - so many subproducts can be selected for that product.

A subproduct can be in many OrderDetails , so ... i'm thinking many2many.