Please help in this example

[AzizSader]

Dear all
In this example has two tables table personnel and projects, and you link between the two tables in a way ( ONE TO MANY )
Can sometimes for more than an employee has to be the same project, for example,


( USER1 ) Has a project and can be (USER2)AND (USER4) they have the same project
Is there a way to do I add the project to a number of staff together

[June7]

Can each person be associated with more than one project and each project can have many people? If yes, this is a many-to-many relationship. Need a junction table.

tblUsersProjects
UserID
ProjectID

[AzizSader]

Very Very Thank You My Dear Teacher
Is it possible to modify the example My Dear Teacher

[June7]

Build table as described.

Use form/subform arrangement for data entry/edit.

Main form bound to project and subform bound to junction table with combobox to select employee.

or

Main form bound to employees and subform bound to junction table with combobox to select project.

This is very basic Access functionality.

[AzizSader]

thank you my dear teacher