Microsoft Office Tutorials and References
In Depth Information
7. In this example, I am going to select to show Full Name and E-mail Address as additional
fields (Figure 7.40).
lookup field to
a custom list
Beneath the additional fields section is the Relationship section, which contains the settings
concerning what happens if an item is deleted from the lookup field’s source list. Should it
not enforce the relationship and do nothing to the items in this list that relate to the items in
the source list that are being deleted? Or, if enforced, should the source list be restricted from
deleting an item that is used by this list, or should the item (or items) on this list that relate to
the original list be cascade-deleted when the original customer record is deleted (if we decide
we won’t need to keep the sales order if the customer is gone, for example).
In this example, you want to keep sales order data history to track sales, regardless of any
loss of clients, so let’s enforce relationship behavior and not allow customer records to be
deleted from the Customers list when there are related items in the Sales list (you can add
a Yes/No field to indicate active versus inactive customers in the future if you must).
8. To enforce relationship, check the Enforce Relationship Behavior box, and make sure
Restrict Delete is enabled (Figure 7.41). Keep in mind that because you are enforcing,
SharePoint will need to index the column. The overhead unnecessary indexing entails is
a good reason to think carefully before enforcing relationship behavior.
setting in the