List Integrity Web Part

Product info:

Developer: Bamboo Solutions

Designed for: MOSS 2007, WSS 3.0

License: Per server

List IntegritySharePoint Web Partallows you to quickly establish a relationship between SharePoint lists that exist on the same or different sites within a site collection to enforce various constraints and perform background housekeeping tasks such as when deleting an item in the parent list, all associated child list items are deleted as well - resulting in no orphaned data. You can include parent list column data in the child list forms as a reference for the user and create all associated child List or Library items directly from the parent list through the Title column context menu.

• Easily create an item in the child list from the Title column context menu option in the parent list.
• Child list item forms can be configured to display reference column data from the parent list.
• The Cascade Delete setting can be configured to prevent the deletion of parent list items if associated items in the secondary list OR to delete all associated secondary list items when a primary list item is deleted.
• Link child lists from different sites to a parent list in another site within the same Site Collection.
• The LinkedListConfiguration list is automatically created for you on the top level site of each Site Collection where List Integrity is activated.
• The Bamboo List Integrity Upgrade Utility is provided to help you upgrade from 2.0 to 2.1 by combining all your configuration lists into one at the top level site (per Site Collection) for easier administration.

First, set up your parent and child lists. Then in each child list, create a new column with the Bamboo Link column type that comes with List Integrity and configure the parent column that links to the child column. You can also include column data from the parent list as reference information that is displayed in the new, edit and display forms of the child list. Once configured, you can create new items in each of the child lists from the drop-down menu of the parent list item. You can then set up Web Part Connections between the parent list and each of the child lists so that data is filtered in all of the child lists when you select an item in the parent list. To make setting up the Web Part Connection faster, List Integrity allows you to automatically create a new column in the child list that links to the column you selected from the parent list while configuring the Bamboo Link column.