Multiselect field related to a children Module

[f.didron]

Hi,

First of all, I'm pretty new to SugarCRM. I'm using SugarCRM 5.2 CE. I'm afraid this might be a noob question but anyway here goes :


I've created a Custom Module called Domain (Simple type, only using Name and Description Fields)

Each Accounts can have several Domains, and Domains can include several Accounts, therefore I created a many to many relationship.

I now have the Domain panel in Account's EditView and I'm pretty happy about that, but users aren't. They would like me to add a Multiple Select Field listing all the domains in EditView so they can select several Domain that would be linked to the Account when saving.

What's the best way to do that ?
I created a dropdown list populated with my module's Db's table, but I don't think that the most elegant way to do it. (Raw query on modules table in custom\include\language\en_us.lang.php)

I feel like I'm missing something obvious (Noob as I am )

[f.didron]

Any idea anyone ?

BR,

Florian