AnsweredAssumed Answered

Bi-Directional Many-to-Many Self Join Relationship

Question asked by grassief on Jan 31, 2019
Latest reply on Jan 31, 2019 by beverly

I have a table of Employees, and would like to link those employees that are related to one another.

 

From the discussions I have read, it seem the only way to do this is to create a join table with two records for each related employee. For example, if Employee 1 is related to Employee 7, the records in the join table would be:

 

Join IDEmployee IDRelative ID
117
271

 

Is there any other way to do this without having to always create two records in the join table?

Outcomes