Hello,
I have 2 lists which are:
#Students
#Tasks
In #Students list i have this elements:
Userid | StudentName | Age
In #Tasks list i have this elements:
Userid | StudentName(databasejoin from #Students)| Task
I really need to have a new element in #Students list which is a (calc or databasejoin with data-where conditions?) element and it must have the same value from Task element of #Tasks list, knowing that both lists have the same StudentName.
The task element is always and only can be defined in #Tasks list.
Imagine that i have inserted a new row in #Tasks. All i need is just to have this updated Task value element in #Students database (SQL) knowing that the StudentName elements are equal.
How could i solve it?Calc or Databasejoin with some DATA-WHERE conditions?
Thank you.
I have 2 lists which are:
#Students
#Tasks
In #Students list i have this elements:
Userid | StudentName | Age
In #Tasks list i have this elements:
Userid | StudentName(databasejoin from #Students)| Task
I really need to have a new element in #Students list which is a (calc or databasejoin with data-where conditions?) element and it must have the same value from Task element of #Tasks list, knowing that both lists have the same StudentName.
The task element is always and only can be defined in #Tasks list.
Imagine that i have inserted a new row in #Tasks. All i need is just to have this updated Task value element in #Students database (SQL) knowing that the StudentName elements are equal.
How could i solve it?Calc or Databasejoin with some DATA-WHERE conditions?
Thank you.