self multi-relationship

Discussion created by gilo05 on Jan 1, 2017
Latest reply on Jan 5, 2017 by erolst



Unfortunately I do not know how to call the relation I need, so I "invented" self multi-relationship.



My db contains clients. For these clients I want to create relationships with other clients.


For example:


client1 is the father of client2

client3 is the firm where client 1 works

client4 is the brother of client 2



How do I get this done?

I need that one client can have multiple relations with different other clients

I need that if client1 is related with client2, that FB is also showing that client2 is related with client1.

The hardest where I do not see a solution is, how to delete a relation.


Maybe someone has experience with this case and could help me how to solve this problem in the most neat and effective way



thanks in advance