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.
- Inspect Movie's movieRoles relationship.
- In the Inspector, click the Advanced Relationship button.
- Ensure that the delete rule is set to Cascade.
- Ensure that the Owns Destination box is checked.
- Check the Propagate Primary Key box.
- Ensure that Talent's movieRoles relationship has its delete rule set to Deny.
- Ensure that Talent's movieRoles relationship owns its destination.
- Set Talent's movieRoles relationship to propagate its primary key.
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.
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.
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?".
Table of Contents 
Next Section