Add Campaigns/Notes (one-to-many) relationship

Question

Hello! 
 We went live with Sugar (11.0) in early summer and are really getting into the swing of things. This forum has been very helpful with some tricky situations and I'm hoping someone can provide some guidance on this one. 
 We're starting to use the Campaigns module. Yes, it's using the old user interface, but it still is very helpful to us. I went to Studio tonight to add a one-to-many relationship with the Notes module so we could keep notes, attachments, etc. with the Campaign module. 
 However, Studio only allows a one-to-one relationship between Campaigns/Notes. If I go to the Notes module to try to add a relationship, it does not allow a many-to-one relationship. So no matter which way I approach this, it appears all I can get is 1 Note per Campaign. 
 Is that true? We've had great luck with Studio in doing what we want to tailor Sugar but this one seems sort of unusually limiting. We don't find any documentation about any limits on this and we'd love to hear from anyone who's tried this. 
 Thank you very much! 
 Bob

Bob Bundy · Answer

Hi Bob, 
 May I offer no code solutions for you to consider. 
 Although you can only relate I note, it will allow you to both a) attach multiple files to the same Note, b) add a 'Comment Log' field to the Notes module c) add a one-to-many relationship from Notes module to Notes module 
 
 Hope that helps? 
 - Vincent

Bob Bundy · Answer

Unfortunately Studio forces some constrains regarding relationship on Campaigns module, removing such constraints is not neither upgrade safe or packageScan safe task. But you can add such a relationship by hand, creating some extended vardefs .