# X and y table relationship access

### What is a Relationship? - Definition from Techopedia

FIGURE Adding the foreign Key field to the Courses table in Design view in the "many" table FIGURE Relationships window A record in Table X has no in Table Y. A single record in Table X has many records in Table Y. Access . A many-to-many relationship refers to a relationship between tables in a database when a parent row in one table contains several child rows in the second. A relationship, in the context of databases, is a situation that exists between two relational database tables when one table has a foreign key that references the.

The left-hand side, these guys cancel out, so we get 2y is equal to the right hand side, you have 20 minus 5x. And then you can divide both sides of this equation by 2.

So you divide both sides by 2. The left-hand side, we just have a y, and then the right-hand side, we could leave it that way. And so now using this, let's just come up with a bunch of x values and see what the corresponding y values are, and then just plot them.

So let me do this in a new color. So let me-- a slightly different shade of yellow. So we have x values, and then let's think about what the corresponding y value is going to be.

So I'll start, well, I could start anywhere. I'll start at x is equal to 0, just because that tends to keep things pretty simple. So it's just 10 minus 0 or So that gives us the coordinate, the point, 0 comma When x is 0, y is So it's going to be right here at the middle of the x-axis.

Creating a one to many relationship in a Access 2013 College Database

And you go up 10 for the y-coordinate. So it's right over here. So that's the point 0 comma Let's do another point.

### Graphing a linear equation: 5x+2y=20 (video) | Khan Academy

Then, put Access to work to combine data in queries, forms, and reports. To see all existing relationships defined for a database, open an Access template, go to the Database Tools tab, and select Relationships. Before you can add a relationship, you need at least two tables.

Ideally, you build all of your tables first. Understanding the Relationships view The lines in the Relationships view indicate connections between the tables. In the following image, the table on the left is the parent table. The table on the right is the child table. Lines and symbols show you how your tables are related: It keeps your data synced. In our illustration, the number 1 indicates that there can be only one matching record in that table. In the Orders table shown here, only one record matches each order.

In the Order Details table shown here, an order indicated by its order ID may appear more than once, because the same order may include multiple products. Types of relationships between tables There are three types of relationships between tables: When each item in each table only appears once. For example, each employee can have only one company car to use. For more information, see Create one-to-one relationships.

## Graphing a linear equation: 5x+2y=20

When one item in one table can have a relationship to multiple items in another table. For example, each purchase order can include multiple products. When one or more items in one table can have a relationship to one or more items in another table. Click in the Field Name column just below the last field in the table and type a name for your new lookup field. In the example, type Region as the field name. In the Data Type column, click the arrow and select Lookup.

The Lookup Wizard starts. On the first page of the Lookup Wizard, select I want the lookup field to get values from another table or query.

### Video: Get started with table relationships - Access

More options appear in the dialog box. Select the name of the table or query that should provide the values for your lookup.

In the example, select Table: After you select the table, use the Which value do you want to display in your lookup list to select the field that you want to use as a display value for your lookup field. By default, Access selects the first text field it can find in the selected table. In the example, you would leave the selected field, Title, as the display value.

Use the Do you want to sort the items in your lookup list to set the sorting, if you want. The name of the table in this question varies depending on which table you selected in step 5.

Be careful when choosing that option.