help with table relationships

[trc14]

Ok im extremely new to this whole Access thing so I have several questions. First, let me give you an idea of what I am attempting: I am a member of a committee and we are involved in multiple projects. Each person is either inactive (working on no projects) or active (working on 1 or more projects). I want to set up a table that lists the member names, contact info, and which project(s) they are currently working on. I set up the basic table (not sure if its set up correctly or not though) but since some people are on more than one project, how do i make it so i can enter multiple values for the "Current Project" field? Also, I would like to make another table that lists Project Names, members (the members that are working on each specific project), and project description. How do I set it up so that under members (on the project table), it will gather the info from Member table (the one with contact info and such) and automatically list which members are working on each project? Also, There is one Leader per project and the rest working on it are just normal members. Can anyone suggest a good way to display who is leader on each project?

if this is confusing, just ask and i'll try to clarify for you

thanks, TRC

 

[trc14]

bump.......

 

[RV]

Bumping after one hour and one minute after starting a thread is considered to be quite rude.
Remeber that next time as it will likely result in getting no reactions at all
Remember that we provide free advice here.
If you're in a hurry, well, though luck.

Basically, you need 3 tables.
tblProject => project data
tblMember => member data
tblProjectMember => junction table.

You need a junction table to split up the many to many relationship you've got between tblProject and tblMember (as a project will come with multiple members whereas a member can be participating in multiple project).

Run a search on junction in the forum.

Before you start, I suggest to get a bit more familiar first with the ins and outs of normalization, relational databases and Access itself.
What you intend to set up requires basic knowledge.
And it's you we will have to do the building.

After that, a good approach is to put your daily processes on paper.
Next, use the paper to determine with your table structure could look like.
Start building and come back if you run into any issues after you've created your first draft version.

Also, have a look at the sample databases in the forum.
They should help you on your way.

RV

 

[trc14]

thanks for the help, i'll certainly look into that

also, i apologize for the bump, i wasnt try to be rude

Is there a way I can enter multiple values in tblMember under the project field, and same for tblProject under the members field

 

[RV]

Is there a way I can enter multiple values in tblMember under the project field, and same for tblProject under the members field

Don't.
You assign members to a Project hence you create rows in your junction table.

RV