I have two list in the Sahrepoint Foundation 2010 site.
1) Projects with Title and members(Person or Group - multiple selection)
2) Tasks (Team site default) - added lookup column Projects form the first list (required)
Now I want to assign task given users in the projects list.
ex. I have users A,B,C,D,E and Two Project P1 and P2
I have defined that P1 project has users A,B,C so task is distributed/assigned between this members, not to D and E
I need some validation or lookup which restrict selection or D and E.
View Complete Post