Database Reference
In-Depth Information
TIP
Access web apps don't use the Relationships page to create and manage relationships.
Instead, they use fields set to the Lookup data type. For information about this data type,
see “Allowing only values in other tables” in Chapter 6, “Maintain data integrity.”
In this exercise, you'll create relationships between one table and two other tables. Then
you'll test the referential integrity of one of the relationships.
2
SET UP
You need the MyTables database you worked with in the preceding exercise to
complete this exercise. If necessary, open the database. Then follow the steps.
1
On the
Create
tab, in the
Tables
group, click the
Table
button to create a new table.
Before we add fields to this table, let's save it.
2
On the
Quick Access Toolbar
, click the
Save
button, name the table
Orders
, and
click
OK
.
3
To the right of
Click to Add
, click the arrow, and in the data type list, click
Number
.
Repeat this step to create a second field that has the
Number
data type.
4
Rename
Field1
as
CustomerID
and
Field2
as
EmployeeID
.
Each order in the Orders table will be placed by one customer and will be handled by
one employee. Let's create relationships between the Orders table and the Customers
and Employees tables so that we don't create records for orders from customers who
don't exist or that seem to have been handled by employees who don't exist.
5
Close the
Orders
table.
TIP
You cannot create a relationship for an open table.
6
On the
Database Tools
tab, in the
Relationships
group, click the
Relationships
button to open the
Show Table
dialog box.