I am trying to create what SEEMS like it should be a simple application in Notes. The basic database is a one that holds documents related to safety metrics. Each document has a category and a subcategory. A simple Notes view can show the documents grouped by category and subcategory.
Where the design gets a bit difficult (for me anyway) is the security/access. The user has requsted that the application be designed so that documents of each subcategory be visible to some users but not others and that they can modify that access on their own (without using the ACL). (Note that each category can have completely different subcategories.)
I have no idea how to design this. I would use groups and roles in a relational database - enabling or disabling subcategories depending upon the user's membership in specific roles. However, within Notes, I don't have access to functions like @UserNamesList and @DbColumns from within views to allow me to filter what documents are selected, so I'm at a bit of a loss.
I admit, I'm a little out of my element here. Notes development is not my forte. I've tried a number of approaches that just don't work. My gut feeling is that I'm just not thinking about this problem from a Lotus Notes perspective.
Does anyone have any suggestions how you might go about this or can you point me to some resource (book or website) that might explain how to do this in Notes?