- What are relationships in Access?
- How do I link two databases in Access?
- How do I link two field lists in Access?
What are relationships in Access?
A relationship in Access helps you combine data from two different tables. Each relationship consists of fields in two tables with corresponding data. For example, you might have a ProductID field in a Products table and in an OrderDetails table.
How do I link two databases in Access?
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 I link two field lists in Access?
Click the "Arrange" tab, and then click the "Merge" button in the Merge/Split group to merge your selected fields into one.