Mash up List Web Parts can provide an aggregation and connection between SharePoint
Lists. Two or three Lists can be mashed-up to display an aggregated result of related
information across these lists. One list would be defined as a parent list and the other one or two lists as the child lists. A column from parent list can be used
to build the relationship with the child lists. Once the relationship is established,
the resulting display can contain any columns from these lists (parent or child
lists). For example, Customer list (parent list containing information like customer
name, address and phone number) can be mashed up with Contact Lists (a child list).
All the contacts for a company can be grouped and displayed below the Company details.
►
Can mash up two or three Lists. Lists can be on the same site or different site
or web application.
►
Any column can be selected (one or two columns can be used) to establish the relationship
across the lists. Once the relationship is established, any columns across the parent
and child lists can be displayed in the Data View.
►
Data can be grouped and displayed based on the relationship defined. The tree format
allows the users to expand and collapse the grouped data.
►
Display data can be exported as CSV file or printed to a PDF file.
►
New items can be created in the Child lists. The column which is used to join the
master and child lists will be assumed to the key. This key value will be automatically
stamped in the child items created.