Good Day,
I would like your help or opinion regarding what is the best solution for this problem, I want the Email_manager field to be filled up with the data coming from the email field (their personal Email address.
Thanks In advance
Example of what Simon mentioned for you.
Hello @Grail030510 You can simply join your table to itself with manager=Name as key of the left join.Best regards,Simon