Setting a custom 'Relate' field with SOAP

[mngibso]

SugarCRM Professional
Version 5.0.0g

I have a custom 'Relate' filed on the Opportunities Module. This is used to relate an Opportunity with an Account. I can set the value through the SugarCRM web interface to the name of an account.

However, when I use set_entry to try and set the custom field to the name of an Account, it doesn't work. No error is returned, the value simply is not saved.

Is there anyway to set this field through SOAP?

Thanks,
Mark

[andopes]

Hi, Mark

All relate field are composed by 2 fields: the field_name (non-db), which is the field you are trying to save and the field_id (saved into database). I believe you have to use the set_entry passing this field.

Cheers

[mngibso]

All relate field are composed by 2 fields: the field_name (non-db), which is the field you are trying to save and the field_id (saved into database). I believe you have to use the set_entry passing this field.

Cheers

Thanks! That did it. Although it looks like both the field name and field id are stored in the opportunities_cstm table.

[andopes]

All custom fields are stored into _cstm table to avoid modify the schema of default tables.
But these fields are recognized by sugar as regular fields.

[rtpl_developer]

I need to set the entries into related tables of custom module. My table name is course_contacts_c and my main module name is course. I need to insert the course and contact id into course_contacts table. Please let me know how to do this using soap?