Answers.Body: <p>Yes, you would have to change the civicrm_membership_type table, in columns relationship_type_id and relationship_direction. Be careful though as these are multi-valued field, so if you inherit the membership based on multiple relationship types you will need to store CONCAT_WS(X'01', {type_1}, {type_2});</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-12-17T19:25:17.293Z
Answers.Text: Note that the already created membership won't inherit magically after you've updated the database so you will need to update them, either using the UI or the API.
Answers.UserDisplayName: samuelsov
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-06-23T02:48:08.513Z
Answers.LastActivityDate: 2016-06-23T02:48:08.513Z
Answers.UserDisplayName: cividesk
Answers.Body: <p>It's a long time since this question was asked but there is now an extension to help with this: <a href="https://lab.civicrm.org/extensions/membershiprelationshiptypeeditor" rel="nofollow noreferrer">https://lab.civicrm.org/extensions/membershiprelationshiptypeeditor</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-11T12:35:58.883Z
Answers.LastActivityDate: 2020-03-11T12:35:58.883Z
Answers.UserDisplayName: Aidan
Body: <p>We've decided that the way we initially setup civimemberships for our organization does not meet our needs. We need to extend membership to employees of member organizations so that employees will receive email communications sent to member organizations.</p>
  
  <p>CiviCRM does not allow this setting to be changed through the UI. It is something I can change through the database?</p>
  
Tags: <civimember>
Title: Is there any way to add "Relationship Type" to a membership type that already has members?
ThreadText: # Is there any way to add "Relationship Type" to a membership type that already has members?
  
  (Asked by: username_0 on 2016-06-22)
  
  We've decided that the way we initially setup civimemberships for our organization does not meet our needs. We need to extend membership to employees of member organizations so that employees will receive email communications sent to member organizations.
  
  CiviCRM does not allow this setting to be changed through the UI. It is something I can change through the database?
  
  **Tags:** civimember
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2016-06-23. Score: 2
  
  Yes, you would have to change the civicrm\_membership\_type table, in columns relationship\_type\_id and relationship\_direction. Be careful though as these are multi-valued field, so if you inherit the membership based on multiple relationship types you will need to store CONCAT\_WS(X'01', {type\_1}, {type\_2});
  
  > **Comments:**
  > **username_2**: Note that the already created membership won't inherit magically after you've updated the database so you will need to update them, either using the UI or the API.  
  
  ---
  
  ### Answer by username_3 on 2020-03-11. Score: 0
  
  It's a long time since this question was asked but there is now an extension to help with this: <https://lab.civicrm.org/extensions/membershiprelationshiptypeeditor>
  
  
  ---
  
  