set values in a child
Hi there I am fighting a little with setting a marker in a child based on a value in the parent.
The case is that I have for example a project nr which is the parent and the children are persons which should perform different jobs in this project. On a daily basis the persons update that they have done the job by chosing to set a choice field to 1 (Task done) and that is how it should be, and when this choice has been made I lock this particularly record for further update, however the other persons in the same projects are still open for update until they make the same choice. So far so good - so here comes the problem :
Let us say that for example one of the persons has not made the choice even if he is finished with the task, and at the same time the administrator closed the project on the parent site (the project nr), then I would like to secure that all the children in this project had the marker "task done" set.
anyone who knows how to do it ??
rgds
Leo
9 replies
-
If the child table is called Child then in the Trigger after update of the open / closed field put this code
if 'open / closed' = 2 then for a in Child do a.Choice := 1 end end
-
That was super - work as intended - thank you so much
Have a nice Sunday
rgds
Leo
Content aside
- 6 days agoLast active
- 9Replies
- 66Views
-
3
Following