Storing fields related to a relationship

[tickletoe]

Hello,
I am new to sugarCRM and am enjoying getting to know it and thanks in advance for any help here.

I wanetd to know the best way of storing information that relates to a relationship between two modules. For example: Accounts and Contacts have a many-to-many relationship and I want to store a field called status that is related to the Account/Contact. This field will have different values for each Account/Contact relationship.

SugarCRM has created a table called accounts_contacts but this seems to only hold the keys (account and contact) to the reationship. Do I need to add extra columns to this table? Or do I need another module called AccountContact? Or something else?

Can this be done in studio. I don't want to rush into modifying code if it can all be done via the admin gui.

Many thanks
Scott

[andopes]

Hi Scott

This is possible but can not be accomplished through Studio.
You need to write some code.
Take a look at relationships calls_users and opportunities_contacts. The related code can be found at modules/Calls/Call.php and modules/Opportunities/Opportunity.php

Cheers

[tickletoe]

many thanks for you reply.

[cumanacr]

Hi Scott

This is possible but can not be accomplished through Studio.
You need to write some code.
Take a look at relationships calls_users and opportunities_contacts. The related code can be found at modules/Calls/Call.php and modules/Opportunities/Opportunity.php

Cheers

Hi André, I trying to do same Scott is doing, I already understood that I need to do some coding, but I have a BIG doubt:

IF i do this changes, will it be upgrade safe?

Thanks in advance

Cheers

Cristian Umaña