Hi, using 4.2 Final (July 2015).
I understand the M:N relationships you can add via an intermediate entity as this: You have 2 1:M relationships where the M for both relationships is on the intermediate entity, you can then add an M:N between the 2 entities that are on the 1 ends.
Is it possible to add an M:N relations where the common entity is on the 1 end of both relationships . For example, you have 3 tables, order_items, products, and product_suppliers.
order_items M:1 products ( a product can be on many orders)
product_suppliers M:1 products (a product can be supplied by many suppliers)
Want to add a M:N between order_items and product_suppliers.
This doesn't seem possible as the "is related via" combo for order_items is empty presumably because it is not on the 1 end of any relationship.
Thanks,