Many-Many Form Multiple People to One Project

[ramasule]

Hello,

I have done some reading in the forums and tutorial site and thanks to the help of many members here I am learning lots thanks!

My question of the day (Hour ) is I have a
ProjectTbl
ProjectID *Defined by user*
Project.StartDate
Project.EndDate

PersonTbl
PersonID *Autonumber*
Person.LastName
Person.FirstName

I have built a form which I can add multiple people to one project but when I look in the table only the person who the relationship was linked to gets the subtable.

Then I researched a Many-Many relationship and this solved that issue, now I can put multiple people on a project and multiple projects on people.
PersonProjectTBL
PersonProjectID *Autonumber*
PersonID
ProjectID

However how do I now make a form where I select a project and associate more then one person with this project?
I think I need to somehow increment the PersonProjectTBL and add to it as I go.

The layout I would like to have is:

Combobox 1: Selects the Project (After Select use a (queary ??)) to load in
Combobox 2 and 3 with people.
Combobox 2: Select a person to load into project.
Combobox 3: Select a second person to load into project.

I dont expect a full answer a link or multiple links is very appriciated, even a search topic of what to look for.

Thank you for your time,

Derek L

 

[dcobau]

have you considered a subform?

If you have a form that contains unique information (person v. project depends on your output requirements) with a subform in it listing the related information should do the job. Maybe.

Dave

 

[ramasule]

I'm looking for suggestions. I just started using access 3 days ago so I'm plently slow at alot of things.

I'm planning on (hence my other post on date) on doing searches on people and on projects to see what people belong to what project and vise versa.
Also I want to see if a project dedline is approaching and or if it is past the deadline.

I will look into these "subforms" and see whats up with it. All I know is that with a Many-Many I can see in the person table and in the project table what people are tied to what project.

Thanks for your time,

Derek L