Understanding relationships?

[Orchid28]

I'm a little unclear as to how I can go about with my relationships. I have two tables. The first table shows all of the company's risk record which are projects that we have finished and have not finished or projects that are in progress. The second table shows the risk records' Control ID which is like an ID for each risk record (I have about 100 records by the way). This second table is like a reference section that catergorizes what control ID each risk record falls under. Here's an example of what I have in each Table:

Table 1: (Risk Record)

Type

Criticality

Rating

Status/Actions

Issues

Resources required

Start Date

End Date

Completion status

Risk Number

Table 2: (Controls)

Risk Number

Type

Control Description

Control Sub Number

Control Sub enhancement

So far Risk number is the Primary Key. But now what? I don't understand what script I'm suppose to use, or how to use it, if I should make a button that leads from Table 1 to Table 2.

My manager wants to be able to find a risk records control ID. So how do I go about this? Sorry if this all seems confusing. Please ask any questions to clarify! Your help is deeply appreciated!

[mr_vodka]

If you put the related Control field from table 2 on your layout for table 1 it should display for you. Your manager could even search in this field which would find all records in table 1 that has the related matching criteria in table 2. That being said, you are asking pretty vague questions so perhaps you can come back with more specific ones?

[Orchid28]

Ok so Table 1 has all our records of the projects we are currently working on and it also lists projects that are finished. My manager wants to be able to easily search for a certain project from Table 1 and find its "Control number" and what the control number means from Table 2 (sort of like a reference table). I've decided to make a button on Table 1 that will lead to Table 2. Right now I have this button and when I click on it, it goes to Table 2. Table 2 has none of my records listed from Table 1. so Table 2 only has ONE record for all 100 records from Table 1. Am I suppose to import data to Table 2? The two main relationships I have for both tables are Risk Number and Type.

Hopefully this makes sense. I could make Table 2 into the same layout as Table 1, BUT Table 1 already has other related fields such as a scorecard. My manager wants 2 tables so the data is not all meshed into one layout (one Table).

[mr_vodka]

Okay. You are missing some key concepts here. The layout is not the table. A layout reflects data from the perspective of the table occurrence. The table is the where the data is stored.

You would still keep the data in 2 tables, but you can put a related referenced field on the layout for your first table and it would only show you the data related from table 2.

I would highly recommend you reading this whitepaper. It would help you better understand the product.

Key Concepts