Dashboard > WOProject / WOLips > ... > Tutorials > Creating a Many to Many Join
  WOProject / WOLips Log In View a printable version of the current page.  
  Creating a Many to Many Join
Added by chuckhill, last edited by chuckhill on Jan 10, 2007  (view change)
Labels: 
(None)

Q. I used to have to select the 2 entities in EOModeler and do "join in many to many", but I can't find where's that feature in Entity Modeler...

If you select two entities in the entity tree (outline view), you can then click the "New Relationship" action and it will bring up the New Relationship Dialog. I love the new versions of this because it even has an option to add the foreign key attribute for you, too, for non-many-to-many's (though I don't recall what it does if you don't use Project Wonder – it uses prototype 'id' when you have Project Wonder).

In the dialog, you can select which sides (or both) of the relationship are to-many, you can name the relationships, you can optionally have it create a foreign key attribute for one-to-many (single foreign key), or you can select the join attributes.

Site powered by a free Open Source Project / Non-profit License (more) of Confluence - the Enterprise wiki.
Learn more or evaluate Confluence for your organisation.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.5.4 Build:#809 Jun 12, 2007) - Bug/feature request - Contact Administrators