Access Problem


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Access Problem

  1. #1
    Barend Esterhuizen Guest

    Access Problem

    Hi there,
    Is there anyone that can help me to solve this problem please, I need to
    design
    this database with a view different fields. It starts with a Task, for each
    task there is let say five Actions, for each action there is say ten Risks
    and for each risk there is seven Controls. At the end of the day I must be
    able to select any task in a form and the form must display all the
    different Actions, Risks and Controls for that certain Task.

    Task
    Action Risk Control
    Control
    Control
    Control
    Control
    Risk ....
    Risk ....
    Risk ....
    Action ....
    Action ....
    I would appreciate any help thanks,





    --
    Barend



  2. #2
    Alirio Perez Guest

    Re: Access Problem


    Hi!

    Master tables are:
    TaskTable
    Fields (IDTask (PK), TaskDescription)

    ActionTable
    Fields : (IDAction (PK), ActionDescription)

    RiskTable
    Fields : (IDRisk (PK), RiskDescription)

    ControlTable
    Fields : (IDControl (PK), ControlDescription)

    Relations Tables is:
    TaskActionRiskControlTable
    Fields : (IDTask,IDAction,IDRisk,IDControl) all's PK

    with this model there are n actions for task n risk for action, n controls
    for risk.
    validate the input and built it.

    i don't know more details of your app, but
    you could design a table of Actions for a specific Task (IDTask,IDAction),
    a table of Risks for specific Action (IDAction,IDRisk), a table of Controls
    for specific Risk (IDRisk,IDControl)

    i hope help you!

    ap



    "Barend Esterhuizen" <d.esterhuizen@intekom.co.za> wrote:
    >Hi there,
    >Is there anyone that can help me to solve this problem please, I need to
    >design
    >this database with a view different fields. It starts with a Task, for each
    >task there is let say five Actions, for each action there is say ten Risks
    >and for each risk there is seven Controls. At the end of the day I must

    be
    >able to select any task in a form and the form must display all the
    >different Actions, Risks and Controls for that certain Task.
    >
    >Task
    > Action Risk Control
    > Control
    > Control
    > Control
    > Control
    > Risk ....
    > Risk ....
    > Risk ....
    > Action ....
    > Action ....
    >I would appreciate any help thanks,
    >
    >
    >
    >
    >
    >--
    >Barend
    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center