ms access - Update field on the same table -

i have 4 fields, "name", "email", "supervisor's name" , "supervisor's email"

how do query fill supervisor's email column based on field supervisor's name , find his/her email on same table ?

if can create supervisor's email address based on his/her name, there not need fill field it. create , have it.