Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Suggestions Needed To Build Assignment List

Discussion in 'Information Technology' started by Steve, Jul 28, 2006.

  1. Steve

    Steve
    Expand Collapse
    Guest

    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!
     
  2. Loading...

    Similar Threads Forum Date
    Suggestions needed Interfaith Dialogues Jan 11, 2006
    General Help! Looking for a good clairvoyant/card reader......any suggestions? Please Blogs Jan 25, 2016
    Ways to Connect to The Guru - Suggestions? Questions and Answers May 27, 2014
    Turban Day Suggestions? Sikh Sikhi Sikhism Mar 22, 2013
    Just starting my journey..any suggestions? New to Sikhism Mar 25, 2010

  3. Larry Daugherty

    Larry Daugherty
    Expand Collapse
    Guest

    The form isn't yet the issue.

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

    HTH
    --
    -Larry-
    --

    "Steve" <NoSpam@Spam.Com> wrote in message
    news:zGMdg.3$wA1.2@newsread1.news.pas.earthlink.net...
    > 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!
    >
    >
     
  4. Arno R

    Arno R
    Expand Collapse
    Guest

    "Steve" <NoSpam@Spam.Com> schreef in bericht news:zGMdg.3$wA1.2@newsread1.news.pas.earthlink.net...
    >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
     
  5. Steve

    Steve
    Expand Collapse
    Guest

    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" <Larry.NoSpam.Daugherty@verizon.net> 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.
    >
    > HTH
    > --
    > -Larry-
    > --
    >
    > "Steve" <NoSpam@Spam.Com> wrote in message
    > news:zGMdg.3$wA1.2@newsread1.news.pas.earthlink.net...
    >> 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!
    >>
    >>

    >
    >
     

Share This Page