CiviCRM Community Forums (archive)

Here it is how we have configured CiviCRM:

> Everybody is a contact > A contact becomes a member > All members belong to one org. > Member could become trainer.

We have two types of memberships A and B (and the Trainer one) but all belong to the same organization.

Sometimes, a member will have two memberships: Member and Trainer. The trainer then will train other members.  We are using Relationships to track who is training who. (Trainer <-> Trainee)

The issue:  When a trainer is related with a trainee, the trainee assumes the membership of the trainer automatically.  So if the trainee is Membership Type A and the Trainer is Membership Type B, the trainee now shows 2 memberships: Type A and B (by relation).

Is there a way to prevent this?  We want to just keep one contact associated with another for reference.
Can I do it with a custom field?  If so, how do we remove the Relationships tab from the profile overview?

Thanks, hope this is clear to get some help.

Sounds like there is an Inherited Membership Type that is using the Trainer<->Trainee relationship? Is that correct (look in your Membership Types). If so not sure how easy that is to remove, but at least we know what the issue is.

You are correct, the Membership had a Relationship Type assigned to it.  When I go back to edit the Membership, the Relationship Type is not a field but just text, so the question is if setting this column to NULL in the database will mess things up.

The table civicrm_membership_type has a column relationship_type_id which right now has rows with 1 or NULL.  Rows with 1 had a relationship set, so we are going to turn everything in that column NULL.

The hope is that the automatically created memberships will stay there, but no new ones will be created from this point on.