CiviCRM Community Forums (archive)

Hi -

The business logic for our application requires that when a parent organization becomes a member, both their employees and employees of their subsidiaries get access to our database.

I already have the subsidiary relationship between the two organizations tracked.   

My thought is to create a new relationship "subsidiary employee of"  and write a script that adds that relationship to any individual whose current employer has a parent.   I could run the script as organizations join.

Does that seem like a reasonable approach or is there an easier way?

Any assistance would be appreciated

Kurund - Thanks so much for your quick and helpful response.

I think I understand, but just to verify ...
What I actually have is Grandparent Org --> Parent Org --> Employee

I believe you to have said that to accomplish my goal, both "-->" should be represented by "employee of" relationships and the "relationship type" on the "membership type" should also be set to "employee of".

So my mistake is that currently I have "subsidiary of" for the first relationship.  So long as the two relationships are the same and the membership type is set to cascade the "Employees" will be treated as members if "Grandparent Org" is a member.

Is this a maximum of two levels or is it an infinite number?  So Great-Grandparent?

Kurund - Sorry to trouble you further, but I just tried to implement your suggestion and the "employee" relationship seems to be fixed at Org --> employee.  This is not editable in the Relationship Types screen. 

Unfortunately, my relationships are org-->org-->employee.  Is there anyway I can take advantage of the cascade feature in this case?

Thanks for the insight Lobo.  So do you think my first approach seems reasonable.

I've had  a bit more time to think about your comment Lobo, and want to clarify something with you ...

Right now I'm relying heavily on the existing one tier "cascade" where an organization becomes a member and then all their employees are granted membership.  Is that safe to rely on?

If not, that will be a big problem for us, any help in anticipating this change would be appreciated.