make a "real" relationship with field "Relate"

[zaska]

Hola

I need little help understanding the field "Relate". When add it in Studio it creates a table module_cstm and add the related IDs in the corresponding columns when saving a record.
In DetailView the relationship is there, but not in the subpanel. It do not populate the relationship tables.
How can I make when saving a record also to create a "real" relationship between the modules? One way is using custom logic hooks (after_save) and remove all buttons in the subpanel, but I'm sure there's an easy way.

Thanks

[andopes]

Hi zaska

Create a relationship instead.
Go to Admin -> Studio -> <Main Module> -> Relationships
Create a new One to Many Relationship with the <Secondary Module> -> Deploy
SugarCRM will automatically generate the relationship metadata, subpanel entries for the <Main Module> and the <Main Module> field in the <Secondary Module> layouts.

Cheers

[zaska]

Hi andopes,

I've done this. But forgot to mension that I want two (or more) fields and all they to relate to the second module.

Field1 -> selecting contact1
Field2 -> selecting contact2
Field3 -> selecting contact3

Then all these three contacts to relate to the module and show them in the subpanel. Also in DetailView Field1 to show a link to contact1, Field2 to contact2 and so on.

[andopes]

So you can copy the entries on layoutdefs, vardefs and relationship, duplicate them and modify the enough to implement new set of layoutdefs, vardefs and relationships entries.
Go to Admin -> Repair -> Quick Repair and Rebuild

Cheers

[zaska]

When selecting a new contact the old relationship will still be there. I've made it with after_save script.

Thanks

[Gebremedhin]

Hi,

I have been working on something similar but only using one relationship per module. I noticed one of the responses says that if you build the relationship in module builder it should automatically give you the relate field but I have done that and the relate field is not showing. The relationship, subpanels, everything on the back end looks like its there but no relate field and if I try to add one manually it does not create a relationship record in the db. Is that auto-populate feature only with built-in modules? If so, what do I need to do to connect a relate field to a relationship between two custom modules?

Thanks,
Hassab

[edg]

I posted a "how to" in the tutorial section about how to create a Relate field and then associate it with a Sugar relationship.

See the following post: http://www.sugarcrm.com/forums/showthread.php?t=47776