I am trying to be provide a way to manage access to particular documents using 2 different fields that are specified on the document.
These fields are country and category.
Firstly, I would like to be able to manage the access by country. I am aware that I can use readers fields with roles to achieve this but I don't believe this is the best solution as we have 71 countries listed in the application.
I added a names field to my country reference data form to store a list of the readers for that country and then added a @dblookup to this from my main document form. This works well.
However when a new name is added to the country reference document I then need to ensure that all existing documents readers fields are updated. I have written some LotusScript to process this update but am not sure this is the best solution as this could create conflicts etc if documents are being edited by users whilst the LotusScript update runs.
I need to also then be able to grant users access by the category selected on the document using the same method.
For example user1 could be granted access to all documents with a country of France or Germany. Whilst user2 could be granted access to all documents with a category of Sales.
Can anybody propose a better solution for what I am trying to achieve?
Thanks in advance,
Feedback number WEBB8UQDMF created by Andrew Julian on 05/28/2012