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


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