Image this scenario:
I have a list of projects, containing general info for a project.
I have a list of tasks, and every tasks is linked to a project using a lookup column towards the projects list (using the title field).
In SharePoint 2010 I can select additional columns of the projects list when adding the lookup column.
I want to filter the list of tasks based on the project manager (person column in the projects list) or on the project status (choice column in the projects list) or on the project year (a number column in the projects list).
When adding the lookup field, I can select the Title column as main reference column, I can add the project year column as additional column, but I cannot select the project manager or the project status columns as additional fields.
How can I add these columns as well in order to filter my tasks list on these fields?
Thanks in advance for any help on this!
View Complete Post