This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi guys, I'm attempting to achieve this: Product Table - Id (int) - Usual information RelatedProduct Table - Id (int) - ProductId (Points to Product) - RelatedProductId (Points to Product) The relationship is as indicated. The RelatedProduct table really only just points to the Product table. It is, essentially, a list of related products of a product. With that set up in the database... the designer (after dragging in RelatedProduct) - sets up a (through RelatedProduct) link on Product as well as two 1 to Many associations to RelatedProduct. I can't save at that point but after I change it to an Auto Through Entity, it can but it just doesn't work as I expect it. I'm only ever going to be entering from the angle of Product.RelatedProducts and hopefully returning a List How can I achieve this ? Cheers! |
|
|
|
|
I've gone ahead to switch the one-to-many association between RelatedProduct.AlternateId -> Product.Id to a one-to-one relationship. That means I'll be able to traverse Product.RelatedProducts which affords me a list of (Related & Product[myself]) records. |
|
|
|
