Relationships : Get in a variable the fields of "relate" records

[anokirda]

Hello everybody, first of all sorry for my english

I'm developing in SugarCRM Professional 6.1, i have a little problem to retreive information about relate objects (in a view or elsewhere). I didn't find a simple way to do this in the official guide, maybe advanced Sugar Devs could help me.


To simplify my problem : Module A and module B have a oneToMany relationship (for example, a module Hotel with a module Room, or a module Computer with a module Component).

Is there a function to put (in a variable table) all the fields of the relate objects, when you consult the "main" module ?

For example, in the DetailView of a record of the module Hotel, i would like to get in a variable all the fields of the records Room linked to that Hotel, by the relationship. It will allow me later to contruct customized dashboards for my different views (I have a lot of modules and a lot of relationships).

I would like to avoid massive SQL request if possible ...

Thanks by advance, and congratz for this very useful forum !


Anokirda, Switzerland

[anokirda]

Hum this is not the right forum i guess, i'll repost is in the right section. Sorry.