SharePoint Service 3 – custom view from many lists
Hi
I am running W2k3 using SharePoint Services 3.0. I have a few lists which link to each other via lookup columns. I would like a view to display data which links across all lists. Can you provide a way to accomplish this?
Here is my sample which does not work the way I would like:
List "Company"
Column 1: "Company Name"
Column 2: "Phone #"
List "Employee"
Column 1: "Full Name"
Column 2: "Cell #"
Column 3: "Company" which is of type "Lookup" which pulls from the above list
List "Meetings"
Column 1: "Full Name" which is of type "Lookup" which pulls from the above list
Column 2: "Meeting Title"
Column 3: "Meeting Details"
All of this works well.
Now, what I want is a view which shows info such as (which does not work):
Meeting Title Employee Name Employee Company Name
Budget review John Doh ACME
Sales meeting Jane Doh 7-11
etc
etc
I can display the Meeting Title, and Employee name, but the trouble I'm having is the view cannot pull the company details as it is kind of a 'nested record' from the Name List.
If you have any ideas or alternative ways to accomplish this, any help is appreciated.
Software/Hardware used:
Software/Hardware used:
ASKED:
July 9, 2009 5:12 AM
UPDATED:
August 3, 2009 9:06 AM
Answer Wiki:
Not sure about this, but it definitely worthwhile for you to give a shot!
<a href="http://www.sharepointboost.com/listcollection.html">SharePoint List Collection</a>, which, as the name goes, can congregated lists items from whole sites collection into a view. You can work with data on it and export data into spreadsheet.
Hope this helps!
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
