How can I use the same primary key across multiple tables as a foreign key? I am working on a school project. I have a table of employees with a given employee ID. The employee ID on this table is the primary key. I have already set the employee ID as a foreign key on another table, and I am trying to use it as a foreign key on another table as well. How can I do this? I am currently getting an error message saying "duplicate foreign key". Thanks!
I suspect you are linking the tables backwards.
You can most definitely have multiple tables' FK point to the same table's PK. The FK is defined on the table doing the pointing, not the table being pointed at.