Defining Joins in a Relationship

You define joins in a relationship as follows:

1. Double-click a relationship in the diagram to open its property sheet and then click the Joins tab.
2. Select a key in the Parent Identifier list to create joins on its attributes. If you select <NONE>, the attribute lists are empty and you must specify your own attributes to join.

   The attributes linked by the joins are listed in the Parent Attribute and Child Attribute columns.

   
   
   

   Note:

   You can change the foreign identifier attribute linked by a join by clicking the attribute in the Child Entity list, and selecting another attribute from the list.

3. [optional] If you selected <NONE> from the Parent Identifier list, click the Parent Attribute column and select an attribute from the list, then click the Child Attribute column and select a child attribute.
4. [optional] Select the Auto arrange join order check box to sort the list by the identifier attribute order. If this option is not selected, you can re-arrange the attributes using the arrow buttons.
5. Click OK.