I have been struggling to find a way to a an education record to a non-constituent individual relationship. There is a Blackbaud knowledgebase article here that outlines how you add an education relationship but it takes a lot for granted. Here is the gist of it:
Dim oEdu As CEducation2 Set oEdu = New CEducation2 oEdu.Init REApplication.SessionContext With oEdu .Fields(EDUCATION2_fld_RECORD_ID) = 678 'Selects the record to add the Education record to .Fields(EDUCATION2_fld_SCHOOL_ID) = "Berry College" .Save End With
However where does the 678 come from? For a constituent this is simple. It would be the constituent system id found under the Records_fld_Id field.
However what would it be for a non-constituent individual relationship. After all they can also have education relationship records.
I tried the field Individual2_fld_Id but the error I got back told me that I could not add an education to an organization record! Not very helpful.
In the end, with a bit of trial and error I worked out that you need to put the field Individual2_fld_Relation_id.
This is the id for the corresponding entry in the Records table which consists of both constituents and non-constituents.
Hope this helps somebody.