Called a many to many relationship... ie 1 or more employess can work on 1 or more projects...
You need to normalise the design and move to 3 tables...
so you have the following tables
employees on projects
I do have the tables you listed below:
However, I don't quite understand how to connect them in the relational graph. Also, I'm confused as to how to make the employees show on the projects page. I've been going in circles for days. :(
Every table has a PK (= Primary Key) if you want connect a table to another holding specific info you enter a FK (=Foreign Key) which in the graph can be connected to the PK of the table holding the info.
So for your solution:
Connect PK from Employee to FkEmployee from assignment and
Connect PK from Project to FkProject from assignment.
If you want to see the employees on a project:
Create a layout from the table occurrence "Project" (which is your "projects page" ) and ad a portal from the table occurrence "Assignment" and in the row of that portal you enter the field name from the table occurrence Employee.
That should do the trick :)