How to link two tables together with relationships

I am brand new to Access.

I have two tables:

Employees
Projects


Projects primary key is "Project ID"
Employees primary key is "Employee Name"


I have a field on the Projects table that says "Employees assigned"

I have a field on the Employees table that says "Projects assigned"

I need BOTH those fields, to be linked somehow.

I.e. if I import a spreadsheet into the Projects table, with the value "Johnson, Williams, Smith" in the employees assigned field for Project ID "65" , I want Access to automatically edit the "Johnson", "Williams", and "Smith" records on the employees table, and and for each of those employees records, add "65" to their "Projects assigned field".

Each project can have multiple employees and each employee can have multiple projects.

So its a many-to-many relationship


But I cannot for the life of me get this to work. I need it to update universally, so if I delete a project off Johnson's record, it will remove Johnson's name from that Project record and vice versa.

Could someone walk me through this??

Like Alansidman says, you need a junction table. A sort of middle man if you will. You cannot do a many to many relationship without it. In addition to his link I suggest looking here: http://ms-access-tips.blogspot.com/2...ationship.html