question about Addemailaddress of contact modul

[amao]

I want write a function just like the add Emailaddress of contact modul.
Haven't read all the code of sugarcrm.

The definition of this Email field in editviewdef.php is 'email1', which normally refer to the data field in database.
This 'email1' indicate a including document from (include/SugarEmailAddress/templates/forEditView.tpl).

I just can't figure out, how will it realized.
Hope somebody could descript, how does it works.

[kuske]

Since 5.0.0 Sugar saves the email addresses in an own database table (email_addresses) and any reference of an email address in another table (email_addr_bean_rel). So it should be shure that each email address is only stored once in email_addresses.

If you have a contact this contact has one entry in email_addr_bean_rel for each of its email addresses ( possibly more than 2) with email_addr_bean_rel.bean_id = contacts.id and email_addr_bean_rel.bean_module ='Contacts'.

These records have email_addr_bean_rel.email_address_ids pointing to email_addresses.id records with the Email Addresses.

In 4.51 each contact could have only 2 emails email1 and email2.
In 5.00 the new mechanism was realized and email1 and email2 were removed.
As some custom code did not work after this change in 5.10 the fields email1 and email2 were reanimated and filled with primary email and an other email if available. But they are not stored back to the database !