Re: Link Multiple Criteria

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

Number data type, Long Integer Format.

Steve
santus@xxxxxxxx



"Beetle" <Beetle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:64E6C67E-5BA3-4BB5-ADDE-69667860FC90@xxxxxxxxxxxxxxxx

You can use Autonumber for those PK fields. The Autonumber
data type will never repeat a value. The corresponding FK
fields in tblRiskControls must be Number (not Autonumber).

--
_________

Sean Bailey


"JD McLeod" wrote:

Can the primary key in tblRisks for RISKID and tblControls ControlID be
an
autonumber? Is there a risk that the autonumber may reset and i end up
with
duplicates? Or, should i come up with unique IDs for each risk and
control,
maybe a combination of letters and numbers. thanks.

"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: 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: 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: How to select & display distinct values
    ... Not sure what I did to resolve this, ... with a unique column or set of columns (the primary key). ... CompanyID Autonumber ... My form has two controls, the first being a combo box. ...
    (microsoft.public.access.formscoding)
  • RE: Tables and Forms
    ... trying to correspond the AutoNumber with the amount of records. ... some of the records from the table which caused that AutoNumber to delete. ... If you filter your form, the number of records will change. ... form contains a collection of controls. ...
    (microsoft.public.access.gettingstarted)