I have 2 Custom Lists in SharePoint 2010.
- Reconciling Items
I need to apply row level security on Reconciling Items,
based on the Status of the Reconciliations list item.
Status is a Choice field on Reconciliations...
And Reconciling Items has a lookup field for Reconciliations
I have successfully applied row level security to Reconciliations based on the Status.
Is it possible to apply the same permissions on the related item(s) in Reconciling Items when the Status in Reconciliations changes?
What I've tried...
I set up the same row level security on Reconciling Items, using the lookup to find the Status on Reconciliations. But this doesn't work because it only runs when Reconciling Items created / changes, not when Status changes on Reconciliations.
Then I tried the other direction, adding to the workflow for Reconciliations. But when looking up Reconciling Items from Reconciliations, only the first item found would be affected, not all the items.
Then I thought about adding an additional lookup field, Status, on Reconciling Items. But Choice fields cannot be included from a lookup. Not sure this would work anyway, if I were to change the field to a Single line of text. Don't think it would actually register a change...
Any possible solutions?