Join two charts, with all fields!

[#1]

Hello,

I have a table with tasks, each has a list of subtasks, and another table with a list of subtasks. Each task has also a Work Time, and each Subtask has also its own Work Time. I have joined the two tables so I have each subtask related to its task, but its work time its not related to it, as you can see: (Clave is Task and Subtarea is Subtask)

My question is, can i join the two tables so I can obtain for example, the Sum of the Work Time of all the subtasks of a task?

Thanks !!

Júlia

[alexandros17 · Accepted solution]

If you take a look at the table viewer (the icon with 3 tables) you can see that your tables are associated with a lot of fields that create a synthetic key. try to rename the field of the second table in order to leave only the subtask field associated to the first table.

let me know

[#3]

Yes it worked!!! Thank you very much:D