ASsigning Default values for E Mail Addresses

Hi

Can anyone tell me how to populate an E-Mail Field in a Record in one Table with the value which is in the E-Mail Field in another record in another Table where the IDs of both records are the same?

Many Thanks