Form/List Help

[dhogan444]

Background
I have a table that is a called tblPersonnel - it has default "people" fields (last name, first name, etc.). It has a field called "Skills" which is a lookup to another table called tblSkillsList that allows multiple selections. tblSkillsList includes all the options I want for people's skills.



Basically I want to be able to assign skills to people for example Accounting, QuickBooks, Word, Powerpoint, Programming, Website Design, etc. to keep track of the skills our people have.

The Problem

I want to create a form that lists ALL the skills (not just a dropdown box) so that I can print this out and hand it to them to review. So they can "X" a box if I did not add a skill they have or even cross one out if one is erroneously checked.

How can I easily accomplish this?

[zyltar]

Hi,

In fact as 1 employee have many skills, and 1 skill can be connected to many employee you should have 3 tables :
1: employee
empl_id
empl_name
etc...

2: skills
skills_id
skills_txt

3 st_empl_skills
st_empl_skills_id
st_empl_id
st_skills_id


Your report to check the skills can be done from table skills

You can have a form_employee
which is a master/child form.

Master is employee data like name, etc

Subform will be on table st_empl_skills in datasheet view
and you select the skills from the drop-down list.

I hope it helps.
Cheers