Several people have missed this, but use the relationship wizard in
Entity Modeler. It's my favorite part of the app and it's
unfortunately slightly hidden (I'll have to work on that). Select
two entities in the outline and click Add Relationship. Rather than
just dropping a default named relationship in the relationships view,
it will open the relationship wizard:

You can make to-one, to-many, many-to-many, optionally flatten, have
it create the join attributes for you, the works. You don't have to
fiddle around with "make the to-one attribute, set its prototype, set
its name, create a relationship, pick the model, pick the entity, add
the join, blbahbahblahbalhba". To me, this dialog alone makes Entity
Modeler completely worth the money you paid for it :)
ms
This archive was generated by hypermail 2.0.0 : Thu Oct 04 2007 - 12:53:21 EDT