multiple data in one field

[kkenedy]

Hi -- I'm working on a simple one-table Access database. We would like to add one field where we can keep track of volunteer training. We want one field that would store each department the volunteer is trained to work in.

I tried making a look up table with values I created and also used a look up table pulling from a created "department " table. But both times the table will only accept one value for the field. (For example, I can't use control to highlight two departments and have them both included in the same field.)

Is there a better way to approach this. I really wanted to approach this in the easiest way possible.

Thanks.

[Tanis]

Don't put all your data in one field, it will make querying your DB a nightmare. What happens if a volunteer changes projects or how would you add a volunteer to a project? I would have 3 tables. Table 1, tblVolunteerRec ords. Table 2, tblVolunteer and table 3, tblDepratment. Table 1 consists of 4 fields. ProjectID, Project, Volunteer and Department. Table 2 consists of 2 fields. VolunteerID and Volunteer. Table 3 Consists of 2 fields DepartmentID and Department. Create a form based on tblVolunteerRec ords. Add two comboboxes based on tblVolunteer and tblDepartment.Y ou can delete the controls for Volunteer and Departments. Now when you add a project, you can pick the volunteer and department from the combo boxes.