Hi,

I have a bit of a tricky one I'm not sure how to approach.

I have created an Event custom module and for any Event record, I relate Contacts to it. However, as this relationship (Attendance) also has values associated it, I've implemented it as another intermediate module which contains these fields:

Event 1:m Attendance m:1 Contact

I understand this is a common implementation for such as situation.

It all works fine apart from when adding contacts to an event en-masse.

I want to use a function similar to the Pro editions 'add contacts from report' button that is available to target lists. This uses the standard Widget set based on 'SugarWidgetSubPanelTopSelectButton' but with 'report' as the module and pulling the contact ids back as passthru.



However, this will only work with a regular single relationship between event and contact. As I need to also create the intermediate Attendance record and relate both the event and the contact to that - it's a lot more complex.


I'm looking for suggestions on how best to approach this. Any thoughts?