SharePoint 2007 Lookup Column vs SharePoint 2010
Cascade Delete
SharePoint 2007 : The Lookup column in SharePoint 2007 does not support cascade delete. i.e. if If an Item\Value in the the look-up list is deleted, then all those items referencing that value (as look-up value) will not be delete. This will rather present you with various errors and can also cause errors on the Site page if your are using one of them as filters.
SharePoint 2010 : If an Item\Value in the the look-up list is deleted, then all those items referencing that value (as look-up value) in other lists will also be deleted.
Restrict Delete
SharePoint 2007 : Does not have option to restrict deleting of lookup list items\values.
SharePoint 2010 : Choosing this option would restrict the users from deleting an item in the column in the Look-up list, if the value is being used in some other lists.
Number of columns displayed
SharePoint 2007 : This will only display the chosen lookup column in the referencing list.
SharePoint 2010 : You can now display additional columns from the look-up list, along with the chosen lookup field.
SharePoint 2007 : The Lookup column in SharePoint 2007 does not support cascade delete. i.e. if If an Item\Value in the the look-up list is deleted, then all those items referencing that value (as look-up value) will not be delete. This will rather present you with various errors and can also cause errors on the Site page if your are using one of them as filters.
SharePoint 2010 : If an Item\Value in the the look-up list is deleted, then all those items referencing that value (as look-up value) in other lists will also be deleted.
Restrict Delete
SharePoint 2007 : Does not have option to restrict deleting of lookup list items\values.
SharePoint 2010 : Choosing this option would restrict the users from deleting an item in the column in the Look-up list, if the value is being used in some other lists.
Number of columns displayed
SharePoint 2007 : This will only display the chosen lookup column in the referencing list.
SharePoint 2010 : You can now display additional columns from the look-up list, along with the chosen lookup field.
This comment has been removed by a blog administrator.
ReplyDelete