Getting started with Access tutorial 8.3 how to establish a relationship between tables

Now, create a "relationship" between tables. First, click the "relationship" command under the "Tools" menu to bring up the "relationship" dialog box. A "display table" dialog box is displayed, as shown in, in the "show tables" dialog box, you can add "tables" or "queries" to the "relationship" dialog box. Tutorial 8.3

Now, create a "relationship" between tables. First, click the "relationship" command under the "Tools" menu to bring up the "relationship" dialog box. A "display table" dialog box is displayed, as shown in, in the "show tables" dialog box, you can add "tables" or "queries" to the "relationship" dialog box. Tutorial 8.3

Now we startBetweenCreate"LinkClick"Link"Command,"Link"Dialog box, there is a" display table "dialog box above, as shown in, you can use the" display table "dialog boxCreateLinkAdd "table" or "query" to"Link"Dialog box.

Getting startedTutorial8.3WhatIn the tableBetweenCreateLink"/>

Select both the "Customer Info table" and "Order info table" tables, and click "add" to add them to"Link"Dialog box, click" close "to close the" display table "dialog box. When you need to open it later,LinkIn the dialog box, right-click the table and select the "show table" command.

Getting startedTutorial8.3WhatIn the tableBetweenCreateLink"/>

In theLink"Dialog box contains only the list of fields in" Customer Info table "and" Order info table. WhyCreateLinkWhat about it? In fact, tables are composed of fields.BetweenOfLinkIt is also associated with fields. Let two fields in different tablesCreateAfter the contact, other fields in the table can naturally be used through these two fields.BetweenOfLinkIt is linked together. That is to say, in the "Customer Info table", "company name" and "order unit" FieldsBetweenCreateLinkYou can. In the "Customer Info table" Field List, select the "Company Name" item, press and hold the left mouse button, and drag the mouse to the "Order unit" item in the "Order info table", and release the left mouse button, then, "edit" appears on the screen.Link"Dialog box.

Getting startedTutorial8.3WhatIn the tableBetweenCreateLink"/>

This dialog box can help us editCreateOfLinkCan be changed through the list box on the leftCreateLinkSource of two fields. You can click "new ..." Button to create a newLinkOr click "Join type" to select a join type for the join. Click the join type button. In the displayed dialog box, select the third item and click OK. Return to "edit"LinkClick create.

Getting startedTutorial8.3WhatIn the tableBetweenCreateLink"/>

Now there is a line between the two lists, connecting the order company and company name options. Close"Link"Dialog box, and save theLink"Layout modification. Between tablesCreateLinkThat's it.