Linking records

[Ashley25]

Hello,

I'm new to Access and recently had a project assigned to me that i'm not sure how to complete. The thing that i keep getting stumped on is trying to link specific existing records to a different table.



For example I have a table that is for a certain security control, lets call them Control1 and Control2, each control has security information for them such as the person in charge of the control and the parameters for the control. I'm trying to figure out how to take the name of the person in charge of each control from the control table and link it to a separate table that will be for all the names so for each control i can compare the names of the people in charge to the other controls.

Then for the parameters and the description of each parameter I want to do the same. For each control there are varying parameter. For Control1 there are 3 parameters and for Control2 there are 4 parameters. Is it possible to take those parameters and the descriptions of each and link them to another table so they will all be in the same field?

This is what i'm hoping the linked table will look like so when the description is added in the main table it will also upload to this table.

[June7]

What is a 'security control'? What is this database for?

Primary and foreign key fields are used to associate records of related tables.

Don't include repetitive info in data. Why repeat "Parameter C-" in every record? Why have the colons?

[Ashley25]

Sorry this is a database that will be used in a system security plan template. My bosses just gave me a general idea of what they want to be put into the database but not what they plan to do with it. Is that information important/needed to figure out how to do this link?

I'll go back and take out the repetitive information I see that it is not really needed.

Is it possible for me to link the Parameter field and the Description field from these two tables



and have them link to a table that looks like this



So when the descriptions are added/updated in the original table's fields they will update in this table?

[June7]

I expect that information will be important to you in designing db.

Why do you have two identical tables and not 1 table?

The dataset in the third image could be achieved with a UNION query using the two tables, except for the ID field. The result is essentially the 1 table should have to begin with.

[ssanfu]

Why do you have two tables for the security controls??? Are the structures different? They look the same..

I would guess you didn't sit down with paper and pencil (or whiteboard) and design the table structures and relationships.

Can you explain what you are trying to do in plain English? Don't worry about database terms... Pretend we met in the park and tell me about the project.


And welcome to the forums

[Ashley25]

Each of the tables are for different controls that i have to connect them to later but that's not what i'm concerned with.

For the UNION query there is a SQL required and I'm very very new to all this so I'm not sure how to go about doing that. I apologize for how confusing what I'm asking is. I've never worked with Databases before and have no idea what I'm doing here.

[June7]

I still don't see why you have multiple identical structure tables. The tables are for what controls and how do you plan to 'connect' them?

Why do you then want to combine the tables? There is no wizard or designer for UNION query. Must type into SQL View of query builder.

Maybe this will help you http://www.rogersaccesslibrary.com/

[Ashley25]

So there are several different security controls for this report. Right now I'm only focusing on two of them. For each control there are several Sections of Control information

This is the table that I'm using from the word document for just one of the controls:



Right now I'm just focusing on the parameters for the first two controls.

So first off I'm creating a table for each of the controls but I want there to be one large table that has all the parameters and their descriptions listed in one table so it looks like this in the end



Does that make more sense?

[June7]

Separate tables does not make sense. Use one table and filter the records as needed for each 'control'.

I am still clear on what a 'control' is. Is this a business process or policy?