Hello everyone, this is what I'm working on. I have two lists:
- column user and column project that the user is assigned to.
- (a library): a list of all the projects.
I was wondering, how, by every row that is created in the first list (so adding a user and a project) it is possible to grant the user permissions on this project's reference in the second library (the projects library). Example: ProjectLibrary:
- Project1
- Project2
- Project3
The first list:
- user1 project1
- user1 project2
- user2 project2
- user2 project3
- user3 project3
Now I want to give each user permission to see the project he's assigned to so that when he opens a third form, a combobox filled with projects will only show the projects he has permissions on.
Thank you so much!