Suggestions Needed To Build Assignment List

[Steve]

I need some suggestions on how to set up a form ---

It is actually a subform. The main form is Job and the subform is employees
assigned to tasks for the job. Say the tasks are Task1, Task2 and Task3. The
employees may have SkillLevel1, SkilllLevel2 or SkillLevel3. Each subform
record basically consists of two comboboxes, one to select the task and one
to assign an employee to the task. Multiple employees may do each task. The
first employee assigned to Task1 must be a SkillLevel1 employee. Other
employees assigned to Task1 may be any skill level. Employees assigned to
Task2 and Task3 may be any skill level.

Any suggestions on how to build the list of task assignment in the subform
and insure that Task1 has at least one SkillLevel1 employee?

Thanks!

 

[Larry Daugherty]

The form isn't yet the issue.

You need to more clearly express your schema and the desired outcome.

HTH

 

[Arno R]

I need some suggestions on how to set up a form ---

It is actually a subform. The main form is Job and the subform is employees
assigned to tasks for the job. Say the tasks are Task1, Task2 and Task3. The
employees may have SkillLevel1, SkilllLevel2 or SkillLevel3. Each subform
record basically consists of two comboboxes, one to select the task and one
to assign an employee to the task. Multiple employees may do each task. The
first employee assigned to Task1 must be a SkillLevel1 employee. Other
employees assigned to Task1 may be any skill level. Employees assigned to
Task2 and Task3 may be any skill level.

Any suggestions on how to build the list of task assignment in the subform
and insure that Task1 has at least one SkillLevel1 employee?

Thanks!

I guess we do need a real resource for this problem.
Maybe PCDatasheet will pop in and make you an offer ??

Arno R

 

[Steve]

TblEmployee
EmployeeID
EmpName

TblSkillLevel
SkillLevelID
SkillLevel

TblEmployeeSkill
EmployeeSkillID
EmployeeID
SkillLevekID

TblJob
JobID
JobDesc
JobStartDate
JobEndDate
etc

TblTask
TaskID
Task

TblJobTask
JobTaskID
JobID
EmployeeID
TaskID

The main form is based on TblJob and the subform is based on TblJobTask.