Multiple form handling

  • Thread starter Thread starter Christopher Bellar
  • Start date Start date
C

Christopher Bellar

I am attempting to create a form based on three tables.
The first table is a list of employees that work in my
office. The second table lists a number of skills that are
used by each employee in my office (like a one to many
relationship). The third table contains proficiency levels
for each skill (from none to expert). With that said, how
do I create a form that will allow me to select an
employee, choose a skill, and select the proficiency for
each skill. Is it possible to do that with an Access form?
I am running into problems with getting the data to do
what I want it to do. Because of that, my form doesn't
function properly.
 
I am attempting to create a form based on three tables.
The first table is a list of employees that work in my
office. The second table lists a number of skills that are
used by each employee in my office (like a one to many
relationship). The third table contains proficiency levels
for each skill (from none to expert). With that said, how
do I create a form that will allow me to select an
employee, choose a skill, and select the proficiency for
each skill. Is it possible to do that with an Access form?
I am running into problems with getting the data to do
what I want it to do. Because of that, my form doesn't
function properly.
Click to expand...

You need to add a fourth one: you have a many (employees) to many
(skills) relationship, which requires a new table to link the employee
table to the skills table. It should have fields for EmployeeID (and
no other employee information); the Skill, or the primary key of the
Skills table; and a field for the proficiency.

Typically the Form would be based on the Employee table; on the form
you would have a Subform based on this fourth table, using EmployeeID
as the master/child link field. On the Subform you would have a combo
box based on the Skills table (to allow the user to select a skill),
and another combo based on the proficiency table (bound to the fourth
table's proficiency field).


John W. Vinson[MVP]
(no longer chatting for now)
 
Back
Top