I have a custom Attachments module that I created with the Module Builder. Through the Studio, I created a many-to-many relationship between my custom Attachments and Notes (I had to do it through the Studio because in Module Builder, Notes does not appear as an option in the Relationship dropdown). So far so good.

Now, the problem is that I can't for the life of me figure out how to relate my attachments to my notes during an import of my attachment records. I have already imported all of my notes. I have a note ID field on my attachments records. I just can't figure out what to map that ID to. I tried creating a relate field in my Attachment module that relates to the Notes module. That didn't work.

I could probably get to my desired result by directly manipulating the DB, but our goal is to have this used by people who don't have the skills to do that. So I'm really looking for a way to get this done through the import interface.

Any help is much appreciated!

Using SugarCRM CE 5.2k; MySQL 5.0.45