SharePoint Service 3 – custom view from many lists

5 pts.
Tags:
SharePoint
SharePoint List View
SharePoint Services 3.0
Windows Server 2003
WSS 3.0
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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!

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following