Hi, I have the situation whereby in the same database, i have 2 type of information, FAQ and problem. I need the user to see only the data created under his Country in the problem site and allow him to see all the FAQ. I have more than 10 country where in each country there will be a designated user. Beside the country, there are information in the problem which i want to hide for some user who did not have a specific role.
What is the best way i can do the view? I understand that Private view can do the job but when the design change, i may have problem changing the private view.