Edit an Entity in a Relationship

When an entity participates in a relationship, it may have to be modified. For example, you might be testing a project and find that a join path is required, or that you need to specify a quantity.

  1. On the Semantic Objects tab, click Relationships, and then double-click an existing relationship. Or, to create a new relationship, on the Insert menu, click Relationship.
  2. Select an entity, and click Edit Entity.
  3. In Select Entities, select an entity that will be involved in the relationship.
  4. If relevant, select either or both: Field tells "how many" (or "how much") of this entity participates in the relationship check boxes, and select the corresponding tables and fields. This enables the relationship to be described as How much cheese is shipped to California or How many people migrated to  New York? In other words, if the common phrasing includes units of measure (pounds, miles, boxes, and so forth), use how much. If there are no associated units, use the how many.
  5. Click Apply.

If the entity is represented by a database object (such as a table), click for more information about the join options.


(c) 1996-1998 Microsoft Corporation. All Rights Reserved.