M
Mark Sayegh
I am new to access and I am working on a project for work.
My problem is that I have two table. The first table is labeled
LeadProjectManager and the second table is labeled ProjectManager. Both
tables have EmployeeID, First Name and Last Name as attributes.
They have a many to many relationship so I created a junction table. My
question is can the junction table contain only one attribute which is
EmployeeID that happens to be a primary key for both tables ?
Please Help.
My problem is that I have two table. The first table is labeled
LeadProjectManager and the second table is labeled ProjectManager. Both
tables have EmployeeID, First Name and Last Name as attributes.
They have a many to many relationship so I created a junction table. My
question is can the junction table contain only one attribute which is
EmployeeID that happens to be a primary key for both tables ?
Please Help.