Question about Table Design

[marf]

I have a TblProject that describes all aspects of a project (Num, Date,
Decription, etc). I need to include people resources attached to this
project. Here is the issue... a project could have anywhere from 2 people to
say 10 people assigned to it. These people are all employees (in the
Employees table) from different depts.

I have a table called TblResource that links to the Employees table...

What does the form need to look like?? How do you allow for entering a
different number of resources for every project???

 

[Mr B]

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.

 

[Jeff Boyce]

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