How to combine fields from modules?

Question

The scenario is that there are 3 modules.

1. an abstract address module.
2. a 1:1 relationship between addresses and objects + a role (like opportunities_contacts described here)
3. an object module

In objects there should be address fields showing up dependent on a dropdown. If the object is of type Museum -> one address with role 'main', is it of type X -> 3 addresses with roles 'a','b','c'...

The addresses should appear as if they were belonging to the module itself (for reproting, campaigns...). Addresses entered in the object module should create a role dependent on the dropdown (for example: 'main' and 'alternative').

Besides that there should always be a Subpanel for addresses with additional roles.

What needs to be done to integrate fields from addresses module into this objects module?

Could one also use this to override the default accounts/contacts/leads structure without breaking campaigns module...?

Answer 1

You can leverage Sugar Logic or use a technique like this...

http://developers.sugarcrm.com/wordpress/2012/03/13/howto-grab-fields-from-a-related-record-without-sugar-logic/