I have 2 lists in SharePoint and one of them is a list of applications and another is tasks. The task list has a lookup column pointed at the App List: Name column. My App list contains some other information such as Department Name.
TASK LIST
– Work Number
– Resource
– Name
– Priority
– Application Name (Lookup to Application List)
– Completion Date
TASK LIST
– Application Name
– Department (Lookup to Departments List)
– Primary Dev
New View
– Task Name
– Task Status
– Task ETC
– Application Name
– Department Name
– Primary Dev
I am basically trying to create a view
that includes some columns from the
Task List and all of the columns from
the Application list. I know in SQL
this is simply a JOIN to get the other
fields, but I'm not sure how to do
this with SharePoint views.
Best Answer
I'm sorry if this is way off (my head is too full of post-workweek buzz to fully grasp your problem statement), but is this what you are looking for?
http://blah.winsmarts.com/2007-10-Performing_joins_between_SharePoint_lists.aspx http://office.microsoft.com/en-us/sharepointdesigner/HA100991441033.aspx