How do you link two table in two access database?

Answer

Creating Relationships between Tables

Relationship is an association established between common fields (columns) in two tables. A relationship can be one-to-one, one-to-many, or many-to-many.

When you create a relationship between tables, the related fields don't have to have the same names. However, related fields must have the same data type unless the primary key field is an AutoNumber field. You can match an AutoNumber field with a Number field only if the FieldSize property of both of the matching fields is the same. For example, you can match an AutoNumber field and a Number field if the FieldSize property of both fields is Long Integer. Even when both matching fields are Number fields, they must have the same FieldSize property setting.

Opening the Relationship window

1. Click Tools Menu
2. Click Relationships
3. Select the table from the Show Tables dialog box
4. Click Add to Add the tables
5. Click Close button

Note: To open the Show Table dialog box
Click Relationship Menu
Click Show Tables

To create a New Relationship

1. Click Relationship Menu
2. Click Edit Relationship
3. Click Create New button
4. Click Left Table Name arrow & Select the table
5. Click Right Table Name arrow & Select the table
6. Click Left Column Name arrow & Select the field name
7. Click Left Column Name arrow & Select the field name
8. Click OK button
9. Click Create button

For more details refer http://msaccess.batcave.net

First answer by FatD. Last edit by FatD. Contributor trust: 30 [recommend contributor]. Question popularity: 7 [recommend question]