Tackling this SugarCRM concept

[snippet]

I have a Custom Module, a Package Module and a Type Module.

The Custom Module is to handle records for a business. This is how it should work.
A Custom Module record has a Type and this Type holds relationships many Package Module records (like a container). These Package Module records should go hand in hand with the Custom Module record if it is of Type x.

A Custom Module record cannot have one Package Module record, it's usually two or more together.

My idea was:

---

Custom  Module -> relates (Many to One) -> (custom) Type Module

Type Module -> relates (Many to Many) -> (custom) Package Module

So that when you create a new Custom Module record, you attach a Type, and the attached Type attached its Package Module records.
---

Programmatically its not a problem, I can follow up the relationship. But visually for record entry etc, its a problem.

This does not work as I envisioned in Sugar, since the Package Module is not directly related to the Custom Module.
I wanted that when a Type is selected, its related Package Module appears as a subpanel on the Custom Module view.

How would you go around relating this together with Sugar? Or would you set it up differently?

Thanks

[andopes]

In order to do that you need to create a function based subpanel.
Double check modules/Campaigns/metadata/subpaneldefs.php and modules/Campaigns/Campaign.php in order to understand how to implement that.

Cheers