Multiple Contact Relate Fields in Accounts Module

[avadtechnologies]

I have added multiple contact relate fields to the accounts module. This is to allow us to select a Primary Contact, Technical Contact, and Billing Contact. However when you save a record if they are empty they give the following error:

No Match for Field: Primary Contact
No Match for Field: Technical Contact
No Match for Field: Billing Contact

When I select a contact for each field and click save it saves the record but does not save any of the contacts I have selected for those fields... not even the default Primary Contact one.

[avadtechnologies]

Does anyone know if this is possible and if so can they explain how? Would like to have multiple Contact Select fields in the accounts module for Primary, Technical, and Billing.

[Verdatum]

I had a similar problem and the solution I found was that each of the relate fields must have its own (id) field. so if you are trying to relate more than one field to a single module you have make the second and third relate to a different module and then edit the php file manually to change the id fields for example you would need contacts_id for one and contacts_id2 for the other. Good Luck!

[zalkind]

Hi Verdatum,

How did you do this?
What files did you changed?
Did you have to change the database?

[zalkind]

I did it on my own.

Each relate fields really must have its own (id) field, but i did it changing the database.

at my problem i had to have two contacts relate fields at opportunities module.

I created only the 1st relate field at studio and changed the following at database (through phpadmin):

Table fields_meta_data, record 1 (the id field):
changed id from Opportunitiescontact_id_c to Opportunitiescontact2_id_c
changed name from contact_id_c to contact2_id_c

Table fields_meta_data, record 2 (the relate field):
changed ext3 from contact_id_c to contact2_id_c

Table opportunities_cstm, the structure
changed the name of the field contact_id_c to contact2_id_c

These changes made my 1st relate field to use contact2_id_c instead of contact_id_c.

After this i created the 2nd relate field and used it without modifications (once now sugar created and used contact_id_c)

If you need a third relate field you have to change the database the same way for the 2nd field.