creating relate fields/relationship in 5.1

[mikesolomon]

I created a new module in 5.1 using the module builder

One field was a relate field to accounts name

I then created a one to many relationship from accounts to my new module in studio

on my first test I called the field account & when I tested it the records did not show in the accounts subpanel

I then tried again calling the relate field account_name

This time the subpanel worked

The way the relationship is working is via a new table account_aa_atest_c

Under 5.0 I created one-many relationships manually and there is no link table

Should I now change the relationships on my existing tables to the new format with a link table?

[andopes]

Hi Mike

In the Sugar 5.1 when you create a relationship 1:M between two modules you don't need to create a relate field.
Sugar automatically add a relate field into layout, just based on relationship rules.

Cheers

[mikesolomon]

Hi Mike

In the Sugar 5.1 when you create a relationship 1:M between two modules you don't need to create a relate field.
Sugar automatically add a relate field into layout, just based on relationship rules.

Cheers

Thanks that helps

Same question applies tho - should I go back through my custom modules and amend them?

[agcopley]

Hi Mike

In the Sugar 5.1 when you create a relationship 1:M between two modules you don't need to create a relate field.
Sugar automatically add a relate field into layout, just based on relationship rules.

Cheers

But then this begs the question, why have a field of type relate in Studio??

Any ideas to how one should differentiate between using a relate field and creating a relationship?

Thanks
Andrew

[andopes]

Hi Andrew

I suggest you to always create a new relationship, because this automatically create all necessary features to get it working.
Creating a Relate Field through Studio require to create the relationship and subpanel by hand.
I believe SugarCRM will improve the Relate Field in the further releases.

Kind Regards

[agcopley]

Hi Andrew

I suggest you to always create a new relationship, because this automatically create all necessary features to get it working.
Creating a Relate Field through Studio require to create the relationship and subpanel by hand.
I believe SugarCRM will improve the Relate Field in the further releases.

Kind Regards

Andopes,
Thanks for that! I thought I'd mastered 5.0, and now they have changed a whole bunch of stuff...would be worthwhile adding this kind of stuff to the wiki.

KR
Andrew