Hello everyone. I am new to this forum and to Access having just finished my first book on it. I have created my own practice database based on my own work location, with several tables including employee, department, and computers. One of the relationships is a one-to-many relationship between the employee.deptID field and deptartment.ID(pri-key). In the relationship view, I now show two relationships for this one. One, the original, and a second one between employee.deptID and department_1.ID which is a duplicate of department. It doesn't seem to hurt anything but I was curious why there are nowtwo of the same relationship ? And what made the duplicate department_1 table show up ?
I don't remember the duplicate table being there when I created the relationship.