Lookup columns offer the capability to enforce column relationships and referential integrity. Two types of relationship behavior can be set: Restrict Delete or Cascade Delete. Both of these settings and their impacts are demonstrated in this video.
Please log in in the pane to the right, to view this video tutorial.
If you are not a member of the site, please look into subscription options.