RE: Link Multiple Criteria

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


For example, if you wanted to enter/view a Risk and
then assign all the associated Controls, you would create
a main form based on tblRisks with a sub form based
on tblRiskControls (the junction table) using RiskID as
the Master/Child link. In the sub form you would use a
combo box bound to ControlID in order to enter the
Controls that relate to that Risk. The Row Source of the
combo box would be a query based on tblControls.

--
_________

Sean Bailey


"JD McLeod" wrote:

Thank Sean. The table structure you described makes sense. Can you
elaborate on the mechanics of how i would populate the third table to "create
the link"? Would i use a form that pulls data from the other two tables? I
looked up this topic in Access help, but it didn't really explaon how the
third table would work. thanks for your help.

"Beetle" wrote:

It sound like you have, essentially, a many-to-many
relationship between Risks and Controls, in which case
you need a third table to manage it. Example;

tblRisks
******
RiskID (Primary Key)
RiskName
other attributes of each Risk

tblControls
********
ControlID (PK)
ControlName
PersonID (Foreign Key to tblPersons)
other attributes of each Control

tblRiskControls
***********
RiskID (FK to tblRisks)
ControlID (FK to tblControls)
any attributes that are specific to the relationship

(RiskID and ControlID would be a combined PK for the above table)

tblPersons
********
PersonID(PK)
FirstName
LastName
Title
other attributes of each person

--
_________

Sean Bailey


"JD McLeod" wrote:

I am creating a database for risk management. In this database, users will
input risks and the controls that mitigate those risks. The problem I am
having in designing the table is that one control may mitigate more than one
risk. I envision a table for the risks which contains all of the details
such as risk type, risk category etc. I then thought I would have a table
for the controls and related data such as performance frequency, person
responsible, etc. Where I am stuck is on how to “assign” (link) one of the
controls to one or more risks. I am just beginning to look at the table
design, so any help or thoughts on how to accomplish this would be
appreciated.
.

Relevant Pages

  • Re: How does a customer get PCI audited?
    ... You can be purple in the face with controls and training, but if you are never PROPERLY tested by a REAL team then you will never know where your REAL risks are. ... You must have a strong understanding of the threat and how the threat might align with your risk and exposure profile. ... Suggesting that anyone build controls without first having a GOOD and REAL assessment is horrible advice. ... PCI-DSS compliance is at least a small defence. ...
    (Security-Basics)
  • Re: How does a customer get PCI audited?
    ... threat and how the threat might align with your risk and exposure profile. ... the job of a penetration testing company is to test the security of an existing IT Infrastructure and the effectiveness of policies and procedures to a degree. ... Those customers hire us to launch unannounced penetration tests against their infrastructure as a means to test how well their personnel follow the incident response policies. ... That said, penetration tests and vulnerability assessments do not perform complete reviews of a businesses controls, but they can challenge them to a degree. ...
    (Security-Basics)
  • Re: Link Multiple Criteria
    ... Number data type, Long Integer Format. ... You can use Autonumber for those PK fields. ... Is there a risk that the autonumber may reset and i end up ... input risks and the controls that mitigate those risks. ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Link Multiple Criteria
    ... You can use Autonumber for those PK fields. ... fields in tblRiskControls must be Number. ... Or, should i come up with unique IDs for each risk and control, ... input risks and the controls that mitigate those risks. ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Link Multiple Criteria
    ... RiskID ... RiskID (FK to tblRisks) ... input risks and the controls that mitigate those risks. ...
    (microsoft.public.access.tablesdbdesign)