Need Help with user Permissions
Hi,
I have a table called Projects. In this table there is a record with the name 'Data'
I also have another table called 'Action Items'.
Project and Action Items are in a One - Many relationship. When people add a record in action item, they are REQUIRED to input the Project name which is a reference column.
I also have a user role called Data PM.
Now, I want - When the Data PM ADDS a new record, in the Project Name dropdown they should only see Data. They should however be allowed to VIEW reports and metrics of all the projects.
I was able to make this partially possible by limiting the view access of Projects table to record that contains 'Data'. But by doing this it hides other projects from the reports too. I want all the users to be able to see the reports. How can I make this possible?
I have a table called Projects. In this table there is a record with the name 'Data'
I also have another table called 'Action Items'.
Project and Action Items are in a One - Many relationship. When people add a record in action item, they are REQUIRED to input the Project name which is a reference column.
I also have a user role called Data PM.
Now, I want - When the Data PM ADDS a new record, in the Project Name dropdown they should only see Data. They should however be allowed to VIEW reports and metrics of all the projects.
I was able to make this partially possible by limiting the view access of Projects table to record that contains 'Data'. But by doing this it hides other projects from the reports too. I want all the users to be able to see the reports. How can I make this possible?
