This makes the Accounts table the “Many” side as One customer may have Many accounts. For this example, Access knows that CustomerID is a key of the Customer table so it chooses this field as the “One” side. Upon releasing the mouse button, the Edit Relationships dialog box will appear as below:Īccess will do its best to determine the Relationship Type (almost always it will select One-to-Many). To connect the Customers table with the Accounts table to form a relationship, click on the CustomerID field in the Customers table and drag it over on top of the CustomerID field on the Accounts table. The Relationships screen will now reappear with the two tables displayed as below: Then click on the Close button to close this dialog box. Highlight both the Customers table and the Accounts table as shown below and then click on the Add button. The Show Table dialog box will appear by default. The blank Relationships screen will appear as follows: Next, display the Relationships screen by clicking on the Database Tools tab and then click on the Relationships button as shown below. To close a table, either right-click on the table name in the tab above the table and choose the close menu item, or click the small X to right above the table. Access will halt creation of any relationships if the table are currently opened. To get started, make sure the Accounts table and the Customer table are both closed.
Access uses this information when designing reports, forms and queries that require more than one table to be displayed.
Access has a means to make this relationship explicit using the Relationships screen. In the Bank database thus far, the Customers table is related to the Accounts table by virtue of the CustomerID field appearing in both tables. Recall that one of the main characteristics of relational databases is the fact that all tables are related to one another.
5.5 Creating Relationships Between tables
0 kommentar(er)
