Table of Contents Previous Section

Using the Advanced Relationship Inspector

 There are several additional settings you use to configure a relationship's referential integrity rules. For these, use the Advanced Relationship Inspector.

  1. Inspect Movie's movieRoles relationship.

  2. In the Inspector, click the Advanced Relationship button.

  3. Ensure that the delete rule is set to Cascade.

    If the wizard created relationships for you, the relationship's delete rule should already be set to Cascade. You specified this in the wizard. If you created your relationships by hand, you'll have to set the delete rule yourself.

  4. Ensure that the Owns Destination box is checked.

    As with the delete rule, if the wizard created relationships for you, the relationship's Owns Destination box should already be checked. If you created your relationships by hand, you'll have to check this box yourself.

  5. Check the Propagate Primary Key box.

    A relationship that propagates its primary key propagates its key value to newly inserted objects in the destination of the relationship. In this case, checking the Propagate Primary Key box means that if you create a new MovieRole and add it to a Movie's list of MovieRoles, the Movie object automatically assigns its movieId value as the value for the new MovieRole's movieId property.

    This option is usually used with relationships that own their destination. For more information on propagates primary keys, see "Where Do Primary Keys Come From?".

  6. Ensure that Talent's movieRoles relationship has its delete rule set to Deny.

  7. Ensure that Talent's movieRoles relationship owns its destination.

  8. Set Talent's movieRoles relationship to propagate its primary key.

Table of Contents Next Section