AnsweredAssumed Answered

How can I add a field to a relationship?

Question asked by Pitou Pitou on Mar 28, 2014
Latest reply on Dec 11, 2018 by Robert Sinclair

I m new on SugarCRM and english isn't my mother language.

I have SugarCRM CE 6.5.15 and i want to add fields on my relation. I'm going to explain with a short example :

I have my entity "A - Person" and my entity "B - Skill". I have made with "the module builder" a relation "N-N".

So for example i have Jack and Jones whose have a same skill. For example (Speak French) but don't practice it since the same time. So i don't want to create two entities "skill" with two different years of experience. I just want to add the field "Year of experience" in the relation table.

Like this -> | Id - IdA - IdB - Years |

Adding this field with phpmyadmin is easy, but how can i force SugarCRM to make a "Form" when i add a Skill to a Person. Because now, i can just select a skill and the skill is directly added to a person.

I have searched after an answer but didn't find it. Maybe there is an answer for a question like that but i didn't find it.

Thank for your answer,