19.12.2020
00:45
Between Item lists there is relationship 1:C. How row in the parent Item list can be protected to be updated or deleted if in the child item list there is a row referenced on ID of row in the parent Item list. Is there any sample that can help to overcome this issue. Both Item lists are in the same step.
21.12.2020
00:51
Hi Slavko,
I haven't tested these ideas, but they could work:
Preventing updating:
You could set up an editable restriction on each column in which you check whether there's a child row in the other item list.
Preventing deletion:
I would disable the delete button in general. Instead you could add a picker to where the user can mark the rows to delete. On save/path transition you can check whether it's save to delete the row. I don't know your situation but maybe it's not even necessary to delete the row. I prefer to mark the rows as invalid/not necessary.
Without knowing the circumstances, I would switch to a two step approach unsing the wizard step option.
Best regards,
Daniel
21.12.2020
17:49
Hi Slavko,
I haven't tested these ideas, but they could work:
Preventing updating:
You could set up an editable restriction on each column in which you check whether there's a child row in the other item list.
Preventing deletion:
I would disable the delete button in general. Instead you could add a picker to where the user can mark the rows to delete. On save/path transition you can check whether it's save to delete the row. I don't know your situation but maybe it's not even necessary to delete the row. I prefer to mark the rows as invalid/not necessary.
Without knowing the circumstances, I would switch to a two step approach unsing the wizard step option.
Best regards,
Daniel
Thanks Daniel, I just wanted to check if there is any other solution to control the integrity and relationship between the Item lists that would not negatively affect user experience. Your proposal will be applied.
Thanks again
BR
Slavko
