marf,

First, I assume that your TblResource table has at least the ProjectID and
the EmployeeID fields in it.  This will allow you to create records in this
table for each employee that assigned  to any project.

Threre are two basic ways that you can show the multiple employees assigned
to one project.

Probably the method would come to mind first for most developers, would be
to use a sub form and just use the Master and Child properties to link the
child form to the master form.  Using this method as you move from project,
you can either have each single employee's info displayed as as single record
and move through all employees that are currently assigned to that project or
you can make the sub form to be a continuous form which will display all
employee's assigned to the project in basically a list type form with the
capability of other fields from the Employee table displayed for each
employee.

The other method would be to create a list box that would display the
desired data for each employee (this can be a simple as just their name or it
can display name, phone number and other fields).  This list would only
display the employees that area currently assigned to the current project.

Because you are wanting to be able to associate existing employee records
with an existing Project record, you would need list of available employees
from which to select the employees you need to associate with one project.  
Users would then select one or more employees to be associated with the
current project and you would have VBA code that would create the records in
the TblResource table for each selected employee and the current project.

Last you would just refresh the sub form or the list box.

This is a wide overview, but I hope this will serve to answer the questions
you asked and that it will get you started on your project.

It sounds like you are trying to build many of the built-in project
management features that come already built-in in commercial software (e.g.,
Microsoft Project).  Is there a reason you need to reinvent the features in
Access?

Regards

Jeff Boyce
Microsoft Office/Access MVP