R – How to get fields from secondary list that are not identifed in the lookup into a single view

sharepoint

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

Related Topic