How to Add Related Table?

[bazianm]

I need to add a table related to the contacts table. I would like it to be a subpanel of the contacts screen. I can't seem to find a way to add a table in the Studio.

Any ideas how I can do this?

I would prefer to do this through the native interface without having to modify the php code...

Thanks in advance...

[andopes]

Hi bazianm

Does this table represent another module or is this a table out of SugarCRM modules?

Regards

[bazianm]

I think the answer to your question is yes. Let me illucidate.

The table I want to add does not exist in sugar. Basically, I have contacts which represent people invited to a wedding. I want to add a table that will allow us to list the people on a particular invite who accepted the invitation so we can do place cards.

For example, I could have a contact (invitee).

Mr. & Mrs. John Smith and Family

When I get the return it could say that John and Molly are coming along with John Jr., Samantha and little Billy. I will need to create three records in this new table as follows:

Mr. & Mrs. John and Molly Smith
John Smith, Jr.
Samatha Smith
William Smith

Each record would be used to determine their seating and to print the place cards.

Thanks for the response...

[andopes]

Hi bazianm

Thank you for the clarification.
It got pretty clear now!

I suggest you to create a new module (Relatives or something else) and configure it as a subpanel under Contacts.
If you let SugarCRM manager this data you will recognize it is simpler.

Kind regards

[bazianm]

Thanks. I had a feeling from your question that this would be the answer. I am trying to figure out the module builder now. I appreciate the push in the right direction.

[bazianm]

Hi bazianm

Thank you for the clarification.
It got pretty clear now!

I suggest you to create a new module (Relatives or something else) and configure it as a subpanel under Contacts.
If you let SugarCRM manager this data you will recognize it is simpler.

Kind regards

OK, I did that. Parenthetically, I think SugarCRM's mod capabilities are awesome! Really cool what you can do with this. However, I am off topic. I now have one thing left to do. How would I REMOVE the subpanels I don't need. Any way I can hide those subpanels?

If I cannot, I would at least want my new subpanel to be listed first...

[andopes]

Hi bazianm

You can do the following:

Create the file custom/Extension/modules/<ModuleName>/Ext/Layoutdefs/layoutdefs.ext.php

And add some code like that:

 unset($layout_defs["<Module>"]["subpanel_setup"]["<subpanel_module_field>"]); 
  

Obviously replace the <Module> and <subpanel_module_field> by the appropriate values.

<Module>: module you are accessing through DetailView
<subpanel_module_field>: is the field into modules/<Module>/metadata/subpanels.php which refers to subpanel.

Regards

[bazianm]

Got it. I think this should be doable in the user interface, though...

Thanks.