Link two contacts

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

Hi,

I use SuiteCrm for contact management. And I would like to know if I can link two contacts together?

Thank you.

#2

@mio

Contact has the link already. Look at the field which has label “Reports To”.

#3

If the nature of the link is other than “Reports to”, you can creante a custom field Relate or a relationship.

#4

Hi @mio,
Yes, you can join the two contacts together because the link is other than “Report to”, you can create a custom field for the related or id relationship by inner join query.
Like:-

    SELECT table1.column1,....
    FROM table1
    INNER JOIN table2
    ON table1.matching_column = table2.matching_column;


    table1: First table.
    table2: Second table
    matching_column: Column common to both the tables

Thank You