How do I add multiple selections from the same field for a record

[Odick]

I am a beginner creating a database to monitor projects. If I have a fields for Employee Last and Employee First name how can I add more than one employee to a project (record)?

[davegri]

You need two tables. tblEmployees and tblProjects
Basic Access functionality. Make a main form from the Projects table and a subform from the Employees table.
Google form/subform for some video tutorials. Dozens of examples.

[June7]

Assuming an employee can be assigned to more than 1 project, this is a many-to-many relationship which requires 3 tables (unless you want to use multi-value field and I advise not to). This is still basic relational database functionality. Have you studied an introductory tutorial book?

tblEmployees
EmpID
LastName
FirstName
etc

tblProjects
ProjectID
ProjectName
etc

tblProjectEmployees
EmpID_FK
ProjectID_FK


Options for data entry:

1. single form bound to tblProjectEmployees with comboboxes to select project and employee

2. main form bound to tblProjects and subform bound to tblProjectEmployees with combobox to select employee

3. main form bound to tblEmployees and subform bound to tblProjectEmployees with combobox to select project

[orange]

Odick,

Do some basic research on relational database concepts. Work through2 or 3 of the tutorials from rogersAccessLibrary
mention in the articles in this link.
Just as you wouldn't start building a house with a hammer and a 2X4 --Planning and design are critical to databases too.

Good luck with your learning an database.