How to add to a linked record a field from another field

I have a table to input hours for tasks. These task are linked to a country and a profile.
Simple, in generic.
People input 40 hours a week, to profile 1 and country 2.
But I have a problem with a department.

This department, already has more granularity in tasks, and they input 40 horas for a specific task wich is alreadly linked to profile and country.

I can add to the table two columns with profile and country lookup , when they input this task, but i need to copy automatically this field to the original linked field country and profile in another columns.

I read a lot in the forum, but any solution is accomodating to my problem.

Maybe some script?

many thanks for your support

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.