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 ID||Employee ID||Relative ID|
Is there any other way to do this without having to always create two records in the join table?