Suggestions Needed To Build Assignment List

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10408-suggestions-needed-to-build-assignment-list.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10408
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!

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

The form isn't yet the issue.

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

HTH
--
-Larry-
--

"Steve" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10408
news:zGMdg.3$wA1.2@newsread1.news.pas.earthlink.ne t...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10408
subform
> and insure that Task1 has at least one SkillLevel1 employee?
>
> Thanks!
>
>

"Steve" schreef in bericht news:zGMdg.3$wA1.2@newsread1.news.pas.earthlink.ne t...
>I need some suggestions on how to set up a form ---
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10408
>
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10408
> 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

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.





"Larry Daugherty" wrote in message
news:eaqxyzVgGHA.2208@TK2MSFTNGP05.phx.gbl...
> The form isn't yet the issue.
>
> You need to more clearly express your schema and the desired outcome.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10408
>
> HTH
> --
> -Larry-
> --
>
> "Steve" wrote in message
> news:zGMdg.3$wA1.2@newsread1.news.pas.earthlink.ne t...
>> 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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10408
> 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!
>>
>>
>
>