Transferring data from one form/table to another

[Bentleybelle]

My db is currently set up like this:
tblMemberDetails - contains personal info
tblAddresses - holds company address details/phone/email and home address details/phone/email

We now want to restructure our membership to include corporate membership, i.e. one company may have several employes who could be members. This creates a one-to-many relationship, so I have created a new table via a make table qry and transferred company info. The company email address, however, is unique to the individual and I need to transfer this from tblAddresses (displayed in a subform) to tblMemberDetails (displayed in a form). How do I do this, so that it will also allow me to enter new records as new members come in?

Thanks in anticipation