Help with designing Tables

E

Ed

Hello I'm a new user to Access. I am designing a database and I have so far 4
tables:

-Office Directory
-Client Directory
-Project Directory
-Suppliers Directory

I don't know which would be the best way to do so... for example each person
in the Office Dir, may have worked or is working in several of Projects,
which would be the best way to make a relationship for that?

In the Project Dir, to make a Field to select a name from the Office Dir,
and make as much Fields as persons working? The problem is that each time
someone starts working I will have to add a field for his/her name, or is
there a way in which a single Field can include the names separated by commas
or something like that?

Or is there a way in which everytime I add a entry to the Office Dir it adds
a field for that person in the Project Dir and just use it or not for example
with Yes/No?

I hope I was able to explain well, thanks in advance!

Ed
 
J

John Spencer

It seems as if you have a many to many relationship between Project and
Office. This means you should have another table to act as a link between
the two.
Table: ProjectWorkers
OfficeField: value identifying one record in Office
ProjectField: value identifying one record in Project

Then when you need to add a new office to a project, you add a record to
this new table. That sounds complicated, but after you get the table set up
correctly, you will use a form (based on Project Directory) with subForm
(based on the new Table) that will make editing the data fairly
straightforward.
 
Top