In a project, I have two lists that are linked together with a lookup column (it's not the actual scenario, but I simplify it) :
* a parent list, that defines some fields and especially a state field that will follow the life of the object (created, open and archived)
* a children list, that also defines some fields including a lookup field to the parent list and a similar state field for its own lifecycle (created, open and archived)
the life cycle of both kind of objects are linked together. For example, when the parent is opened, all children must be opened too (looks like easy because it's a workflow action from parent, and finding children is simply an activity of the workflow).
Another requirement is to archive the parent when all children are archived.
What is the best approach ?
In the parent life cycle workflow, can I monitor children events (I don't think so :() ?
I can cheat a bit by adding an hidden field "all children archived" in the parent, and set this to true from a child workflow or event. I'm not at ease with this solution as it's not a proper way. Anything else I may dive ?
Any idea, advice, tip, encouragement?
Paying back the community for its help by writing articles :
View Complete Post