Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

First of all, I don't have SP Server installed, therefore I can't write a SP application Secondly, my only tool is SP Designer 2007 I have a Contact List SP list: Name, Email, ...other info, Department I'd like to create another list: Department, Count(*) and update it whenever List 1 is modified. Create a Group By view won't work as I want to have the list 2 as a Data Source on another site web part or maybe I'm wrong and it's possible to display a view (not list) on another site.

Site 1 List 1

John Smith.... Mechanical

James Brown....Procurement

Kevin Jones....Mechanical

Site 2

Data View Web Part

Mechanical 2

Procurement 1

Is that possible?

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.