Transfer data to another table and update a column

[ysml11]

hello, I need some help and ideas if this kind of stuff is doable in appsheet
I am trying to create a project management app which tracks tasks with subtasks separated by tables by each level

specifics:
1. I have multiple tables, Top Level Task, Tickets, subTask1, subTask2, subTask3
2. except Top Level Task, the rest have task_ID, and TLT
3. task_ID is unique for each table and TLT can be duplicated

end goal:
I need to be able to move the row from 1 table to another, except to Top Level Task

data flow:
1. subTask3 - task_ID is unique, TLT is reference to subTask2 task_ID
2. subTask2 - task_ID is unique, TLT is reference to subTask1 task_ID
3. subTask1 - task_ID is unique, TLT is reference to Tickets task_ID
4. Tickets - - task_ID is unique, TLT is reference to Top Level Task ID

example scenario:
row in subTask3 should be in subTask1
need to change the TLT in subTask3 to reference in Tickets task_ID so it will be moved to subTask1

row in subTask1 should be in subTask3
need to change the TLT in subTask1 to reference in subTask2 task_ID so it will be moved to subTask3

[TeeSee1]

An "upward" movement is doable because you have a clearly defined TLT chain but a "downward" movement needs more clarification on how you want to move because there could be multiple lower level entries and you need to specify along which branch to move a row. Perhaps create a completely new track?