How do you create a link table in Access?

Question

In the File name text box, type the name of the source database or click Browse to display the File Open dialog box. Click Link to the data source by creating a linked table, and then click OK. The Link Tables dialog box opens. In the Link Tables dialog box, select the tables you want to link to.

How do you link table fields in Access?

Double-click the names of the tables that you want to relate, and then close the Show Table dialog box. To create a relationship between a table and itself, add that table two times. Drag the field that you want to relate from one table to the related field in the other table.

What is a link table?

Link tables are usually association/bridge tables between different Hub tables in Datavault. They mostly resolve many to many relation between different Hub tables.

Expert · Answer

Double-click the names of the tables that you want to relate, and then close the Show Table dialog box. To create a relationship between a table and itself, add that table two times. Drag the field that you want to relate from one table to the related field in the other table.

Expert · Answer

Link tables are usually association/bridge tables between different Hub tables in Datavault. They mostly resolve many to many relation between different Hub tables.

How do you create a link table in Access?

How do you link table fields in Access?

What is a link table?

Related Questions