J
James Hahn
I have a database with one level of redirection in a table - the employee
table contains a department code as a foreign key, and the department table
includes an employee code (manager) as a foreign key. I want to display
this in the relationship diagram as
employee-->department-->employee_1
and the system appears to accept this OK, but on printing the diagram, or
closing and re-opening it, the relationship has become
employee-->department--
^----------------------
and employee_1 is not related to anything. In other words, the link from
department to employee_1 is re-written as department to employee. This is
technically correct, but it's not what I want to portray. Is there a way
around this, or is this an error in my design?
table contains a department code as a foreign key, and the department table
includes an employee code (manager) as a foreign key. I want to display
this in the relationship diagram as
employee-->department-->employee_1
and the system appears to accept this OK, but on printing the diagram, or
closing and re-opening it, the relationship has become
employee-->department--
^----------------------
and employee_1 is not related to anything. In other words, the link from
department to employee_1 is re-written as department to employee. This is
technically correct, but it's not what I want to portray. Is there a way
around this, or is this an error in my design?