Access8.3 how to establish a relationship between tables

Now let's start to establish a relationship between tables. First, click the relationship command under the tool menu. In the pop-up relationship dialog box, there is also a display table dialog box. Through the display table dialog box, you can add tables or queries that need to establish a relationship to the relationship. in the dialog box, select both the Customer Info table and order info table, and click Add to add them to the link dialog box.

Now let's start to establish a relationship between tables. First, click the relationship command under the tool menu. In the pop-up relationship dialog box, there is also a display table dialog box. Through the display table dialog box, you can add tables or queries that need to establish a relationship to the relationship. in the dialog box, select both the Customer Info table and order info table, and click Add to add them to the link dialog box.

Now let's start to establish a relationship between tables. First, click the relationship command under the tool menu. In the pop-up relationship dialog box, there is also a display table dialog box. Through the display table dialog box, you can add tables or queries that need to establish a relationship to the relationship. go

Select both the customer information table and order information table, and click the Add button to add them to the link dialog box. Click the close button to close the display table dialog box and click right-click the table display command.

In the relationship dialog box, how do I establish a relationship between the fields in the Customer Info table and the order info table? In fact, tables are composed of fields. The relationship between tables is also composed of fields. After two fields in different tables are connected, other fields in the table can naturally be connected through the relationship between the two fields. in this way, you can establish a relationship between the company name in the customer information table and the order unit field in the order information table. You can first select the company name in the Field List of the customer information table, then press and hold the left mouse button and drag the mouse to the order unit item in the order information table and release the left mouse button. The edit relationship dialog box appears on the screen.

This dialog box can help you edit the established link. You can use the list box on the left to change the source of the two fields of the established link. You can click New... Click the button to create a new link or select a join type by clicking the join type. Click the join type button. In the new dialog box that appears, select the third option and click OK. The edit link dialog box is displayed. click Create

Now there is a line between the two lists to link the ordering company and the company name options to close the relationship dialog box and save the changes to the relationship layout to establish the relationship between the tables.