Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution    Let's do it!

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!
    >>
    >>

    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page